Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
This article contains details for various supported operators you can use with Azure DocumentDB.
Aggregation
| Description | |
|---|---|
$facet |
The $facet stage aggregation pipelines allow for multiple parallel aggregations to be executed within a single pipeline stage. |
$geonear |
The $geoNear aggregation stage calculates distances between a specified point and the location field in each document, sorts the documents by distance, and can optionally limit results by distance. |
$lookup |
The $lookup stage in the Aggregation Framework is used to perform left outer joins with other collections. |
$match |
The $match stage in the aggregation pipeline is used to filter documents that match a specified condition. |
Array expression
| Description | |
|---|---|
$arrayToObject |
The $arrayToObject operator is used to convert an array into a single document. |
$concatArrays |
The $concatArrays operator is used to combine multiple arrays into a single array. |
$filter |
The $filter operator is used to filter elements from an array based on a specified condition. |
$indexOfArray |
The $indexOfArray operator is used to search for an element in an array and return the index of the first occurrence of the element. |
$map |
The $map operator in MongoDB is used to apply an expression to each element in an array and return an array with the applied results. |
$reduce |
The $reduce operator is used to apply an expression to each element in an array and accumulate the results into a single value. |
$reverseArray |
The $reverseArray operator is used to reverse the order of elements in an array. |
$slice |
The $slice operator is used to return a subset of an array. |
$sortArray |
The $sortArray operator is used to sort the elements of an array. |
$zip |
The $zip operator is used to merge two or more arrays element-wise into a single array of arrays. |
Array query
| Description | |
|---|---|
$all |
The $all operator is used to select documents where the value of a field is an array that contains all the specified elements. |
$elemMatch |
The $elemMatch operator is used to match documents that contain an array field with at least one element that matches all the specified query criteria. |
$size |
The $size operator is used to query documents where an array field has a specified number of elements. |
Array update
| Description | |
|---|---|
$each |
The $each operator is used within an $addToSet or $push operation to add multiple elements to an array field in a single update operation. |
$positional |
The $position is used to specify the position in the array where a new element should be inserted. |
$pullAll |
The $pullAll operator removes all instances of the specified values from an existing array. |
$push |
The $push operator appends a specified value to an array. |
$slice |
The $slice operator limits the number of array elements that are returned or modified. |
Bitwise query
| Description | |
|---|---|
$bitsAllClear |
The $bitsAllClear operator is used to match documents where all the bit positions specified in a bitmask are clear (that is, 0). |
$bitsAllSet |
The $bitsAllSet operator is used to match documents where all the bit positions specified in a bitmask are set (that is, 1). |
$bitsAnyClear |
The $bitsAnyClear operator is used to match documents where any bit positions specified in a bitmask are clear (that is, 0). |
$bitsAnySet |
The $bitsAnySet operator is used to match documents where any bit positions specified in a bitmask are set (that is, 1). |
Comparison query
| Description | |
|---|---|
$eq |
The $eq operator matches documents where the value of a field equals the specified value. |
Date expression
| Description | |
|---|---|
$dateadd |
The $dateAdd operator adds a specified number of time units to a date value. |
$datediff |
The $dateDiff operator returns the difference between two dates. |
$datefromparts |
The $dateFromParts operator constructs a date from the specified parts. |
$datefromstring |
The $dateFromString operator converts a date/time string to a date object. |
Evaluation query
| Description | |
|---|---|
$expr |
The $expr operator allows the use of aggregation expressions within the query language. |
Geospatial
| Description | |
|---|---|
$geoIntersect |
The $geoIntersects operator selects documents whose geospatial data intersects with a specified GeoJSON object. |
Logical query
| Description | |
|---|---|
$and |
The $and operator joins query clauses with a logical AND and returns all documents that match the conditions of both clauses. |
$nor |
The $nor operator performs a logical NOR operation on an array of one or more query expressions and selects the documents that fail all the query expressions in the array. |
$not |
The $not operator inverts the effect of a query expression and returns documents that don't match the query expression. |
$or |
The $or operator performs a logical OR operation on an array of two or more expressions and selects the documents that satisfy at least one of the expressions. |
Object expression
| Description | |
|---|---|
$mergeObjects |
The $mergeObjects operator combines multiple documents into a single document. |
$objectToArray |
The $objectToArray operator converts a document (object) into an array of key-value pairs. |
$setField |
The $setField operator sets or updates the value of a field in a document. |
Projection
| Description | |
|---|---|
$meta |
The $meta projection operator returns metadata about the query, such as the text score. |