AQL: How to specify a collection that has a dash in the name?

Question

I have a collection called one-two and I would like to list a few of the documents in the collection:

FOR v IN one-two
    RETURN v

But I get the following error: Query: AQL: collection or view not found: one (while parsing)

How do I specify the collection with a - in the name?

I've tried the usual options, ', " and camelCasing it oneTwo but they all fail. The ArangoDB documentation Collection and View Names clearly states that a dash (-) is permitted.

Perhaps hints in https://stackoverflow.com/questions/35804928/how-to-quote-escape-a-field-name-in-aql-for-arangodb — user2864740, Jan 14 '22 at 07:04
Yes, you are right. This should have been made clear in the collection naming page that Dash (-) will need escaping.. — Insectatorious, Jan 14 '22 at 07:17

score 3 · Accepted Answer · answered Jan 14 '22 at 08:14

For normal REST requests operating on such a collection no escaping is needed.

However, in AQL a dash (-) can also be interpreted as a minus operator. That's why in a query, a name with a dash has to be put into backticks: `one-two`

But since this is only relevant for AQL, this information can be found in the AQL Syntax documentation, not in the documentation about collection names that you referenced.

AQL: How to specify a collection that has a dash in the name?

1 Answers1

Linked