aql | asyncio query generator | Reactive Programming library

There seems to be no direct way which is simple and performant enough to do that using AQL.
BUT-
What you can do is use prior knowledge on the Maven layout (how Maven artifacts are stored in the repository), use AQL to query for relevant items (files), and then extract the information you need.

Relying on *.pom files (since every artifact version has exactly one) in the Maven layout (where a . is replaced with a /):

You can use compound criteria for that, using an $and operator.

In your example, change -

According to the performance and server config docs, you can enable caching in several ways.

Your method of adding require("@arangodb/aql/cache").properties({ mode: "on" }); to a .js file in the /docker-entrypoint-initdb.d/ directory should work, but keep an eye on the logs. You may need to redirect log output with a different driver (journals, syslog, etc.) to see what's going on. Make sure to run the command via arangosh to see if it works.

If that's a bust, you might want to see if there is a way to pass parameters at runtime (such as --query.cache-mode on). Unfortunately, I don't use Docker Compose, so I can't give you direct advice here, but try something like -e QUERY.CACHE-MODE=ON

If there isn't a way to pass params, then you could modify the config file: /etc/arangodb3/arangod.conf.

And don't forget about the REST API methods for system management. You can access AQL configuration (view and alter) in the Web UI by clicking on the Support -> Rest API -> AQL.

One thing to keep in mind - I'm not sure if the caching settings are global or tied to a specific database. View the configuration on multiple databases (including _system) to test the settings.

The expression u.program_info[*].program_id returns an array with all program_id attributes from the objects in the program_info array. However, you are comparing this array with the scalar value p.program_id which does match and therefore you get an empty array. I suppose you want to check if p.program_id is contained in user's program_info. That could be done like this:

You need to add an INTO clause to the COLLECT operation, like this for example:

Looks we don't have direct way to achieve this, but you can make use of -spec-vars in order to pass dynamic variables through CLI command. I meant to say we can write a script to pass names of selected repositories in a loop and use --spec-vars as below:

so apparently "text_en" turns "vegetable" to "veget" (stems it) and stores it like that in the view , if "text_en" is also applied to the entry value , it works , for example : search analyzer(doc.type in tokens("vegetable" , "text_en") , "text_en")

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.

You should be able to use something along those lines to iterate through your json: