* Finally FLATTEN and RETURN the output variable */Ģ) A different approach would be, to extend AQL with a function written in JavaScript, that would essentially do the same steps as above. * Append the the result of the last (all the non-defined sort values) query to the results of the definedSortResults into the output array */ * Gather the results of each defined sort value query into definedSortResults */ * Define a dummy collection-array to work with */ Operations like FILTER, SORT and LIMIT can be added to the For loop body to narrow. These have all to be flatten down to the same level in order to be processed as a unique result set (instead of many encapsulated small ones). We have already discussed in our previous chapters that ArangoDB has.

Also, note the FLATTEN function at the outer RETURN statement, which is required, because in the first loop we are getting result arrays for each defined sort value.

After that, the actual AQL statement does its job.

Since this is a dump of a complete database, you can use arangorestore to import this. However, it takes a while to translate the debian package database into arangodb documents, so here is a dump of the Debian Jessie package database.

FOR u IN SORT u.label DESC RETURN u: Sort documents in give collection in descending order based on label. The script used to gather this graph data is available alongside with pyarango.

Then I am setting the defined sort values. Getting Started with ArangoDB: Brief introduction of ArangoDB.

I am first creating an array, which would represent the collection we.That would look like the following snippet, which you can copy into your AQL Editor and run it. The '+1' is the last query, which should get the result of all the other values, which are not defined in your custom sort array and also append these to your output array.

Specifying the sort direction or the sort criteria (attributes or expressions) via bind parameters is not unsupported. If you are defining only a few ones, I guess it will be tolerable, but if you have to define for example tens or hundreds, it will lead to n+1 queries (where n is the number of custom sorted values). FOR d in edgesTest SORT 'd.created ASC' RETURN d.created which will sort all rows by the same string value, resulting in (potentially) undefined order. Mind you, that this does have a performance penalty, because there is one query for every value. Each of those results would then be added to the final output array. 45 SORT example sort users by first and last name ascending. Upload Login Signup Upload Home Explore Login Signup Successfully reported this slideshow. This presentation covers AQL, ArangoDBs query language. The query would run through your sort value array and query the DB for every defined value. This presentation covers AQL, ArangoDBs query language. However, there are ways to accomplish that by yourself. Unfortunately, there is no direct equivalent for that, at the moment.

Arangodb sort