Document and object functions in AQL

AQL provides functions to operate on objects respectively document values

You can use the below listed functions with the object data type. Also see object access for additional language constructs for objects.

ATTRIBUTES()

ATTRIBUTES(document, removeSystemAttrs, sort) → strArray

Return the top-level attribute keys of the document as an array. Optionally omit system attributes and sort the array.

To return the attribute values instead, see the VALUES() function.
To return pairs of attribute keys and values, see the ENTRIES() function.

  • document (object): an arbitrary document / object
  • removeSystemAttrs (bool, optional): whether all system attributes (starting with an underscore, such as _key and _id) shall be omitted in the result. The default is false.
  • sort (bool, optional): optionally sort the resulting array alphabetically. The default is false and will return the attribute names in any order.
  • returns strArray (array): the attribute keys of the input document as an array of strings

Examples

Return the attribute keys of an object:

RETURN ATTRIBUTES( { "foo": "bar", "_key": "123", "_custom": "yes" } )
Show output

Return the attribute keys of an object but omit system attributes:

RETURN ATTRIBUTES( { "foo": "bar", "_key": "123", "_custom": "yes" }, true )
Show output

Return the attribute keys of an object in alphabetic order:

RETURN ATTRIBUTES( { "foo": "bar", "_key": "123", "_custom": "yes" }, false, true )
Show output

Complex example to count how often every top-level attribute key occurs in the documents of a collection (expensive on large collections):

LET attributesPerDocument = (
    FOR doc IN collection RETURN ATTRIBUTES(doc, true)
)
FOR attributeArray IN attributesPerDocument
    FOR attribute IN attributeArray
        COLLECT attr = attribute WITH COUNT INTO count
        SORT count DESC
        RETURN {attr, count}

COUNT()

This is an alias for LENGTH().

ENTRIES()

Introduced in: v3.12.1

ENTRIES(document) → pairArray

Return the top-level attributes of the document as an array of key-value pairs.

To only return the attribute keys, see the ATTRIBUTES() function.
To only return the attribute values, see the VALUES() function.

  • document (object): an arbitrary document / object
  • returns pairArray (array): the attributes of the input document as an array of arrays. Each element is a nested array comprised of two elements with the attribute key and the attribute value

Examples

Return the attributes of an object as pairs of keys and values:

RETURN ENTRIES( { "foo": "bar", "number": 123 } )
Show output

Iterate over the attributes of an object and return an object for each key-value pair:

FOR pair IN ENTRIES( { "foo": "bar", "number": 123 } )
  LET key = pair[0]
  LET value = pair[1]
  RETURN {key, value}
Show output

Iterate over the attributes of an object and return an object for each key-value pair, making use of array destructuring for a more concise query:

FOR [key, value] IN ENTRIES( { "foo": "bar", "number": 123 } )
  RETURN {key, value}
Show output

HAS()

HAS(document, attributeName) → isPresent

Test whether an attribute is present in the provided document.

  • document (object): an arbitrary document / object
  • attributeName (string): the attribute key to test for
  • returns isPresent (bool): true if document has an attribute named attributeName, and false otherwise. Also returns true if the attribute has a falsy value (null, 0, false, empty string "")

The function checks if the specified attribute exists, regardless of its value. Other ways of testing for the existence of an attribute may behave differently if the attribute has a falsy value or is not present (implicitly null on object access):

!!{ name: "" }.name        // false
HAS( { name: "" }, "name") // true

{ name: null }.name == null   // true
{ }.name == null              // true
HAS( { name: null }, "name" ) // true
HAS( { }, "name" )            // false

Note that HAS() cannot utilize indexes. If it is not necessary to distinguish between explicit and implicit null values in your query, you may use an equality comparison to test for null and create a non-sparse index on the attribute you want to test against:

FILTER !HAS(doc, "name")    // cannot use indexes
FILTER IS_NULL(doc, "name") // cannot use indexes
FILTER doc.name == null     // can utilize non-sparse indexes

Examples

Check whether the example object has a name attribute key:

RETURN HAS( { name: "Jane" }, "name" )
Show output

Check whether the example object has an age attribute key:

RETURN HAS( { name: "Jane" }, "age" )
Show output

Falsy attribute values like null still count as the attribute being present:

RETURN HAS( { name: null }, "name" )
Show output

IS_SAME_COLLECTION()

IS_SAME_COLLECTION(collectionName, documentIdentifier) → isSame

Test whether the documentIdentifier has collectionName as collection.

The function does not validate whether the collection actually contains the specified document. It only compares the name of the specified collection with the collection name part of the specified document.

  • collectionName (string): the name of a collection as string
  • documentIdentifier (string|object): a document identifier string (e.g. _users/1234) or an object with an _id attribute (e.g. a document from a collection).
  • returns isSame (bool): true if the collection of documentIdentifier is the same as collectionName, or false if it is not. If documentIdentifier is an object without an _id attribute or anything other than a string or object, then null is returned and a warning is raised.

Examples

RETURN [
  IS_SAME_COLLECTION( "_users", "_users/my-user" ),
  IS_SAME_COLLECTION( "_users", { _id: "_users/my-user" } ),
  IS_SAME_COLLECTION( "_users", "foobar/baz"),
  IS_SAME_COLLECTION( "_users", { _id: "something/else" } )
]
Show output

KEEP()

KEEP(document, attributeName1, attributeName2, ... attributeNameN) → doc

Keep only the attributes attributeName to attributeNameN of document. All other attributes will be removed from the result.

To do the opposite, see UNSET().

  • document (object): a document / object
  • attributeNames (string, repeatable): an arbitrary number of attribute names as multiple arguments
  • returns doc (object): a document with only the specified attributes at the top-level

Examples

Keep the top-level foo attribute, preserving its nested object:

LET doc = { foo: { bar: { foo: 1, baz: 2 }, baz: 3 }, baz: 4 }
RETURN KEEP(doc, "foo")
Show output

Keep the top-level bar attribute, which the example object does not have, resulting in an empty object:

LET doc = { foo: { bar: { foo: 1, baz: 2 }, baz: 3 }, baz: 4 }
RETURN KEEP(doc, "bar")

Keep the top-level baz attribute:

LET doc = { foo: { bar: { foo: 1, baz: 2 }, baz: 3 }, baz: 4 }
RETURN KEEP(doc, "baz")
Show output

Keep multiple top-level attributes (foo and baz):

LET doc = { foo: { bar: { foo: 1, baz: 2 }, baz: 3 }, baz: 4 }
RETURN KEEP(doc, "foo", "baz")
Show output


KEEP(document, attributeNameArray) → doc

  • document (object): a document / object
  • attributeNameArray (array): an array of attribute names as strings
  • returns doc (object): a document with only the specified attributes at the top-level

Examples

Keep multiple top-level attributes (foo and baz), by passing an array of the attribute keys instead of individual arguments:

LET doc = { foo: { bar: { foo: 1, baz: 2 }, baz: 3 }, baz: 4 }
RETURN KEEP(doc, ["foo", "baz"])
Show output

KEEP_RECURSIVE()

KEEP_RECURSIVE(document, attributeName1, attributeName2, ... attributeNameN) → doc

Recursively preserve the attributes attributeName1 to attributeNameN from document and its sub-documents. All other attributes will be removed.

To do the opposite, use UNSET_RECURSIVE().

  • document (object): a document / object
  • attributeNames (string, repeatable): an arbitrary number of attribute names as multiple arguments (at least 1)
  • returns doc (object): document with only the specified attributes at all levels (top-level as well as nested objects)

Examples

Recursively preserve foo attributes, but not nested attributes that have parents with other names:

LET doc = { foo: { bar: { foo: 1, baz: 2 }, baz: 3 }, baz: 4 }
RETURN KEEP_RECURSIVE(doc, "foo")
Show output

Recursively preserve bar attributes, but there is none at the top-level, leading to an empty object:

LET doc = { foo: { bar: { foo: 1, baz: 2 }, baz: 3 }, baz: 4 }
RETURN KEEP_RECURSIVE(doc, "bar")

Recursively preserve baz attributes, but not nested attributes that have parents with other names:

LET doc = { foo: { bar: { foo: 1, baz: 2 }, baz: 3 }, baz: 4 }
RETURN KEEP_RECURSIVE(doc, "baz")
Show output

Recursively preserve multiple attributes (foo and bar):

LET doc = { foo: { bar: { foo: 1, baz: 2 }, baz: 3 }, baz: 4 }
RETURN KEEP_RECURSIVE(doc, "foo", "bar")
Show output

Recursively preserve multiple attributes (foo and baz), but not nested attributes that have parents with other names:

LET doc = { foo: { bar: { foo: 1, baz: 2 }, baz: 3 }, baz: 4 }
RETURN KEEP_RECURSIVE(doc, "foo", "baz")
Show output

Recursively preserve multiple attributes (foo, bar, and baz), preserving all attributes of the example object:

LET doc = { foo: { bar: { foo: 1, baz: 2 }, baz: 3 }, baz: 4 }
RETURN KEEP_RECURSIVE(doc, "foo", "bar", "baz")
Show output


KEEP_RECURSIVE(document, attributeNameArray) → doc

  • document (object): a document / object
  • attributeNameArray (array): an array of attribute names as strings
  • returns doc (object): document with only the specified attributes at all levels (top-level as well as nested objects)

Examples

Recursively preserve multiple attributes (foo and baz), by passing an array of the attribute keys instead of individual arguments:

LET doc = { foo: { bar: { foo: 1, baz: 2 }, baz: 3 }, baz: 4 }
RETURN KEEP_RECURSIVE(doc, ["foo", "baz"])
Show output

KEYS()

This is an alias for ATTRIBUTES().

LENGTH()

LENGTH(doc) → attrCount

Determine the number of attribute keys of an object / document.

LENGTH() can also determine the number of elements in an array, the amount of documents in a collection and the character length of a string.

  • doc (object): a document / object
  • returns attrCount (number): the number of attribute keys in doc, regardless of their values

Examples

RETURN LENGTH({ name: "Emma", age: 36, phone: { mobile: "..." } })

MATCHES()

MATCHES(document, examples, returnIndex) → match

Compare the given document against each example document provided. The comparisons will be started with the first example. All attributes of the example will be compared against the attributes of document. If all attributes match, the comparison stops and the result is returned. If there is a mismatch, the function will continue the comparison with the next example until there are no more examples left.

The examples can be an array of 1..n example documents or a single document, with any number of attributes each.

An attribute value of null will match documents with an explicit attribute value of null as well as documents with this attribute missing (implicitly null). Only HAS() can differentiate between an attribute being absent and having a stored null value.

An empty object {} will match all documents. Be careful not to ask for all documents accidentally. For example, the arangojs driver skips attributes with a value of undefined, turning {attr: undefined} into {}.

MATCHES() cannot utilize indexes. You may use plain FILTER conditions instead to potentially benefit from existing indexes:

FOR doc IN coll
  FILTER (cond1 AND cond2 AND cond3) OR (cond4 AND cond5) ...
  • document (object): document to determine whether it matches any example
  • examples (object|array): a single document, or an array of documents to compare against. Specifying an empty array is not allowed.
  • returnIndex (bool): by setting this flag to true, the index of the example that matched will be returned (starting at offset 0), or -1 if there was no match. The default is false and makes the function return a boolean.
  • returns match (bool|number): if document matches one of the examples, true is returned, otherwise false. A number is returned instead if returnIndex is enabled.

Examples

Check whether all attributes of the example are present in the document:

LET doc = {
  name: "jane",
  age: 27,
  active: true
}
RETURN MATCHES(doc, { age: 27, active: true } )
Show output

Check whether one of the examples matches the document and return the index of the matching example:

RETURN MATCHES(
  { "test": 1 },
  [
    { "test": 1, "foo": "bar" },
    { "foo": 1 },
    { "test": 1 }
  ],
true)

MERGE()

MERGE(document1, document2, ... documentN) → mergedDocument

Merge the documents document1 to documentN into a single document. If document attribute keys are ambiguous, the merged result will contain the values of the documents contained later in the argument list.

Note that merging will only be done for top-level attributes. If you wish to merge sub-attributes, use MERGE_RECURSIVE() instead.

  • documents (object, repeatable): an arbitrary number of documents as multiple arguments (at least 2)
  • returns mergedDocument (object): a combined document

Examples

Two documents with distinct attribute names can easily be merged into one:

RETURN MERGE(
  { "user1": { "name": "Jane" } },
  { "user2": { "name": "Tom" } }
)
Show output

When merging documents with identical attribute names, the attribute values of the latter documents will be used in the end result:

RETURN MERGE(
  { "users": { "name": "Jane" } },
  { "users": { "name": "Tom" } }
)
Show output


MERGE(docArray) → mergedDocument

MERGE() also accepts a single array parameter. This variant allows combining the attributes of multiple objects in an array into a single object.

  • docArray (array): an array of documents, as sole argument
  • returns mergedDocument (object): a combined document

Examples

RETURN MERGE(
  [
    { foo: "bar" },
    { quux: "quetzalcoatl", ruled: true },
    { bar: "baz", foo: "done" }
  ]
)
Show output

Consider to use ZIP() instead of MERGE() if you want to merge a set of disjoint keys and their associated values into a single object.

This could be a pattern like the following where objects with dynamic attribute keys are created and then merged together (here to return a map of distinct attribute values and how often they occur):

RETURN MERGE(
  FOR doc IN coll
    COLLECT value = doc.attr WITH COUNT INTO count
    RETURN { [value]: count }
)

This creates many temporary objects and can be slow if there are thousands of objects to merge. The following pattern using ZIP() is more efficient:

LET counts = (
  FOR doc IN coll
    COLLECT value = doc.attr WITH COUNT INTO count
    RETURN [value, count]
)
RETURN ZIP(counts[*][0], counts[*][1])

MERGE_RECURSIVE()

MERGE_RECURSIVE(document1, document2, ... documentN) → mergedDocument

Recursively merge the documents document1 to documentN into a single document. If document attribute keys overlap, the merged result contains the values of the documents contained later in the argument list.

  • documents (object, repeatable): an arbitrary number of documents as multiple arguments (at least 1)
  • returns mergedDocument (object): a combined document

Examples

Merge two documents with the same top-level attribute, combining the name, age, and livesIn sub-attributes:

RETURN MERGE_RECURSIVE(
  { "user-1": { "name": "Jane", "livesIn": { "city": "LA" } } },
  { "user-1": { "age": 42, "livesIn": { "state": "CA" } } }
)
Show output

MERGE_RECURSIVE(documents) → mergedDocument

Recursively merge the list of documents into a single document. If document attribute keys overlap, the merged result contains the values of the documents specified later in the list.

  • documents (array): an array with an arbitrary number of objects
  • returns mergedDocument (object): a combined document

Examples

Merge a list of two documents with the same top-level attribute, combining the name and age sub-attributes but overwriting the city value in the livesIn sub-attribute:

RETURN MERGE_RECURSIVE(
  [
    { "user-1": { "name": "Jane", "livesIn": { "city": "LA" } } },
    { "user-1": { "age": 42, "livesIn": { "city": "NY" } } }
  ]
)
Show output

PARSE_COLLECTION()

PARSE_COLLECTION(documentIdentifier) → collectionName

Parse a document ID and return the collection name.

  • documentIdentifier (string|object): a document identifier string (e.g. _users/1234) or a regular document from a collection. Passing either a non-string or a non-document or a document without an _id attribute results in an error.
  • returns collectionName (string): the name of the collection

Examples

Parse a document identifier string and extract the collection name:

RETURN PARSE_COLLECTION("_users/my-user")
Show output

Parse the _id attribute of a document to extract the collection name:

RETURN PARSE_COLLECTION( { "_id": "mycollection/mykey", "value": "some value" } )
Show output

PARSE_IDENTIFIER()

PARSE_IDENTIFIER(documentIdentifier) → parts

Parse a document ID and separately return the collection name and the document key.

  • documentIdentifier (string|object): a document identifier string (e.g. _users/1234) or a regular document from a collection. Passing either a non-string or a non-document or a document without an _id attribute results in an error.
  • returns parts (object): an object with the attributes collection and key

Examples

Parse a document identifier string and extract both the collection name and the document key:

RETURN PARSE_IDENTIFIER("_users/my-user")
Show output

Parse the _id attribute of a document to extract both the collection name and the document key:

RETURN PARSE_IDENTIFIER( { "_id": "mycollection/mykey", "value": "some value" } )
Show output

PARSE_KEY()

PARSE_KEY(documentIdentifier) → key

Parse a document ID and return the document key.

  • documentIdentifier (string|object): a document identifier string (e.g. _users/1234) or a regular document from a collection. Passing either a non-string or a non-document or a document without an _id attribute results in an error.
  • returns key (string): the document key

Examples

Parse a document identifier string and extract the document key:

RETURN PARSE_KEY("_users/my-user")
Show output

Parse the _id attribute of a document to extract the document key:

RETURN PARSE_KEY( { "_id": "mycollection/mykey", "value": "some value" } )
Show output

TRANSLATE()

TRANSLATE(value, lookupDocument, defaultValue) → mappedValue

Look up the specified value in the lookupDocument. If value is a key in lookupDocument, then value will be replaced with the lookup value found. If value is not present in lookupDocument, then defaultValue will be returned if specified. If no defaultValue is specified, value will be returned unchanged.

  • value (string): the value to encode according to the mapping
  • lookupDocument (object): a key/value mapping as document
  • defaultValue (any, optional): a fallback value in case value is not found
  • returns mappedValue (any): the encoded value, or the unaltered value or defaultValue (if supplied) in case it could not be mapped

Examples

Translate a country code to a country name:

RETURN TRANSLATE("FR", { US: "United States", UK: "United Kingdom", FR: "France" } )
Show output

The unaltered input value is returned if no match is found in the mapping:

RETURN TRANSLATE(42, { foo: "bar", bar: "baz" } )

If you specify a fallback value and no match is found in the mapping, then the fallback value returned instead of the input value:

RETURN TRANSLATE(42, { foo: "bar", bar: "baz" }, "not found!")
Show output

Note that any non-string input value is implicitly cast to a string before the lookup:

RETURN TRANSLATE(42, { "42": true } )
Show output

UNSET()

UNSET(document, attributeName1, attributeName2, ... attributeNameN) → doc

Remove the attributes attributeName1 to attributeNameN from document. All other attributes will be preserved.

To do the opposite, see KEEP().

  • document (object): a document / object
  • attributeNames (string, repeatable): an arbitrary number of attribute names as multiple arguments (at least 1)
  • returns doc (object): document without the specified attributes at the top-level

Examples

Remove the top-level foo attribute, including its nested objects:

LET doc = { foo: { bar: { foo: 1, baz: 2 }, baz: 3 }, baz: 4 }
RETURN UNSET(doc, "foo")
Show output

Remove the top-level bar attribute, which the example object does not have, resulting in an unchanged object:

LET doc = { foo: { bar: { foo: 1, baz: 2 }, baz: 3 }, baz: 4 }
RETURN UNSET(doc, "bar")
Show output

Remove the top-level baz attribute:

LET doc = { foo: { bar: { foo: 1, baz: 2 }, baz: 3 }, baz: 4 }
RETURN UNSET(doc, "baz")
Show output

Remove multiple top-level attributes (foo and baz), resulting in an empty object in this example:

LET doc = { foo: { bar: { foo: 1, baz: 2 }, baz: 3 }, baz: 4 }
RETURN UNSET(doc, "foo", "baz")


UNSET(document, attributeNameArray) → doc

  • document (object): a document / object
  • attributeNameArray (array): an array of attribute names as strings
  • returns doc (object): document without the specified attributes at the top-level

Examples

Remove multiple top-level attributes (foo and baz), by passing an array of the attribute keys instead of individual arguments:

LET doc = { foo: { bar: { foo: 1, baz: 2 }, baz: 3 }, baz: 4 }
RETURN UNSET(doc, ["foo", "bar"])
Show output

UNSET_RECURSIVE()

UNSET_RECURSIVE(document, attributeName1, attributeName2, ... attributeNameN) → doc

Recursively remove the attributes attributeName1 to attributeNameN from document and its sub-documents. All other attributes will be preserved.

To do the opposite, use KEEP_RECURSIVE().

  • document (object): a document / object
  • attributeNames (string, repeatable): an arbitrary number of attribute names as multiple arguments (at least 1)
  • returns doc (object): document without the specified attributes at all levels (top-level as well as nested objects)

Examples

Recursively remove foo attributes:

LET doc = { foo: { bar: { foo: 1, baz: 2 }, baz: 3 }, baz: 4 }
RETURN UNSET_RECURSIVE(doc, "foo")
Show output

Recursively remove bar attributes:

LET doc = { foo: { bar: { foo: 1, baz: 2 }, baz: 3 }, baz: 4 }
RETURN UNSET_RECURSIVE(doc, "bar")
Show output

Recursively remove baz attributes:

LET doc = { foo: { bar: { foo: 1, baz: 2 }, baz: 3 }, baz: 4 }
RETURN UNSET_RECURSIVE(doc, "baz")
Show output

Recursively remove multiple attributes (foo and bar):

LET doc = { foo: { bar: { foo: 1, baz: 2 }, baz: 3 }, baz: 4 }
RETURN UNSET_RECURSIVE(doc, "foo", "bar")
Show output

Recursively remove multiple attributes (foo and baz), removing all attributes of the example object:

LET doc = { foo: { bar: { foo: 1, baz: 2 }, baz: 3 }, baz: 4 }
RETURN UNSET_RECURSIVE(doc, "foo", "baz")

Recursively remove multiple attributes (foo, bar, and baz), removing all attributes of the example object:

LET doc = { foo: { bar: { foo: 1, baz: 2 }, baz: 3 }, baz: 4 }
RETURN UNSET_RECURSIVE(doc, "foo", "bar", "baz")


UNSET_RECURSIVE(document, attributeNameArray) → doc

  • document (object): a document / object
  • attributeNameArray (array): an array of attribute names as strings
  • returns doc (object): document without the specified attributes at all levels (top-level as well as nested objects)

Examples

Recursively remove baz attributes, by passing an array with the attribute key:

LET doc = { foo: { bar: { foo: 1, baz: 2 }, baz: 3 }, baz: 4 }
RETURN UNSET_RECURSIVE(doc, ["baz"])
Show output

VALUE()

VALUE(document, path) → value

Return the specified attribute value of the document.

  • document (object): a document / object
  • path (array): an array of strings and numbers that describes the attribute path. You can select object keys with strings and array elements with numbers.
  • returns value (any): the selected value of document

Examples

Dynamically get the inner string, like obj.foo.bar would:

LET obj = { foo: { bar: "baz" } }
RETURN VALUE(obj, ["foo", "bar"])
Show output

Dynamically get the inner object of the second array element of a top-level attribute, like obj.foo[1].bar would:

LET obj = { foo: [ { bar: "baz" }, { bar: { inner: true } } ] }
RETURN VALUE(obj, ["foo", 1, "bar"])
Show output

VALUES()

VALUES(document, removeSystemAttrs) → anyArray

Return the attribute values of the document as an array. Optionally omit system attributes.

To return the attribute keys instead, see the ATTRIBUTES() function.
To return pairs of attribute keys and values, see the ENTRIES() function.

  • document (object): a document / object
  • removeSystemAttrs (bool, optional): if set to true, then all system attributes (starting with an underscore, such as _id, _key etc.) are removed from the result
  • returns anyArray (array): the values of document returned in any order

Examples

Get the attribute values of an object:

RETURN VALUES( { "_id": "users/jane", "name": "Jane", "age": 35 } )
Show output

Get the attribute values of an object, omitting system attributes:

RETURN VALUES( { "_id": "users/jane", "name": "Jane", "age": 35 }, true )
Show output

ZIP()

ZIP(keys, values) → doc

Return a document object assembled from the separate parameters keys and values.

keys and values must be arrays and have the same length.

  • keys (array): an array of strings, to be used as attribute names in the result
  • values (array): an array with elements of arbitrary types, to be used as attribute values
  • returns doc (object): a document with the keys and values assembled

Examples

RETURN ZIP( [ "name", "active", "hobbies" ], [ "some user", true, [ "swimming", "riding" ] ] )
Show output