Edit

Share via

ARRAY_CONTAINS_ALL (NoSQL query)

  • Applies to: Azure Cosmos DB for NoSQL, Cosmos DB in Fabric

The ARRAY_CONTAINS_ALL function returns a boolean indicating whether the array contains all of the specified values.

Syntax

ARRAY_CONTAINS_ALL(<array_expr>, <expr> [, exprN])

Arguments

Description
array_expr An array expression.
expr Expression to search for within the array.
exprN One or more extra expressions to search for within the array.

Return types

Returns a boolean value.

Examples

This section contains examples of how to use this query language construct.

Array contains all examples

In this example, the ARRAY_CONTAINS_ALL function is used to check for specific values or objects in an array.

SELECT VALUE {
  matchesEntireArray: ARRAY_CONTAINS_ALL([1, true, "3", [1,2,3]], 1, true, "3", [1,2,3]),
  matchesSomeValues: ARRAY_CONTAINS_ALL([1, 2, 3, 4], 2, 3, 4, 5),
  matchSingleValue: ARRAY_CONTAINS_ALL([1, 2, 3, 4], 1, undefined),
  noMatches: ARRAY_CONTAINS_ALL([1, 2, 3, 4], 5, 6, 7, 8),
  emptyArray: ARRAY_CONTAINS_ALL([], 1, 2, 3),
  noMatchesUndefined: ARRAY_CONTAINS_ALL([1, 2, 3, 4], 5, undefined)
}

[
  {
    "matchesEntireArray": true,
    "matchesSomeValues": false,
    "noMatches": false,
    "emptyArray": false,
    "noMatchesUndefined": false
  }
]

Remarks

  • STATIC-NOTIFY-NO-INDEX-USAGE