This article contains details for various supported operators you can use with Azure Cosmos DB for MongoDB (vCore).
Expand table
Description
$countThe $count stage in the aggregation pipeline is used to count the number of documents that pass through the pipeline.
$facetThe $facet stage aggregation pipelines allow for multiple parallel aggregations to be executed within a single pipeline stage.
$geonearThe $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.
$lookupThe $lookup stage in the Aggregation Framework is used to perform left outer joins with other collections.
$matchThe $match stage in the aggregation pipeline is used to filter documents that match a specified condition.
Expand table
Description
$arrayToObjectThe $arrayToObject operator is used to convert an array into a single document.
$concatArraysThe $concatArrays operator is used to combine multiple arrays into a single array.
$filterThe $filter operator is used to filter elements from an array based on a specified condition.
$indexOfArrayThe $indexOfArray operator is used to search for an element in an array and return the index of the first occurrence of the element.
$mapThe $map operator in MongoDB is used to apply an expression to each element in an array and return an array with the applied results.
$reduceThe $reduce operator is used to apply an expression to each element in an array and accumulate the results into a single value.
$reverseArrayThe $reverseArray operator is used to reverse the order of elements in an array.
$sliceThe $slice operator is used to return a subset of an array.
$sortArrayThe $sortArray operator is used to sort the elements of an array.
$zipThe $zip operator is used to merge two or more arrays element-wise into a single array of arrays.
Expand table
Description
$allThe $all operator is used to select documents where the value of a field is an array that contains all the specified elements.
$elemMatchThe $elemMatch operator is used to match documents that contain an array field with at least one element that matches all the specified query criteria.
$sizeThe $size operator is used to query documents where an array field has a specified number of elements.
Expand table
Description
$eachThe $each operator is used within an $addToSet or $push operation to add multiple elements to an array field in a single update operation.
$positionalThe $position is used to specify the position in the array where a new element should be inserted.
$pullAllThe $pullAll operator removes all instances of the specified values from an existing array.
$pushThe $push operator appends a specified value to an array.
$sliceThe $slice operator limits the number of array elements that are returned or modified.
$sortThe $sort operator sorts the elements of an array.
Expand table
Description
$bitsAllClearThe $bitsAllClear operator is used to match documents where all the bit positions specified in a bitmask are clear (that is, 0).
$bitsAllSetThe $bitsAllSet operator is used to match documents where all the bit positions specified in a bitmask are set (that is, 1).
$bitsAnyClearThe $bitsAnyClear operator is used to match documents where any bit positions specified in a bitmask are clear (that is, 0).
$bitsAnySetThe $bitsAnySet operator is used to match documents where any bit positions specified in a bitmask are set (that is, 1).
Expand table
Description
$eqThe $eq operator matches documents where the value of a field equals the specified value.
Expand table
Description
$dateaddThe $dateAdd operator adds a specified number of time units to a date value.
$datediffThe $dateDiff operator returns the difference between two dates.
$datefrompartsThe $dateFromParts operator constructs a date from the specified parts.
$datefromstringThe $dateFromString operator converts a date/time string to a date object.
Expand table
Description
$exprThe $expr operator allows the use of aggregation expressions within the query language.
Expand table
Description
$geoIntersectThe $geoIntersects operator selects documents whose geospatial data intersects with a specified GeoJSON object.
Expand table
Description
$andThe $and operator joins query clauses with a logical AND and returns all documents that match the conditions of both clauses.
$norThe $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.
$notThe $not operator inverts the effect of a query expression and returns documents that don't match the query expression.
$orThe $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.
Expand table
Description
$mergeObjectsThe $mergeObjects operator combines multiple documents into a single document.
$objectToArrayThe $objectToArray operator converts a document (object) into an array of key-value pairs.
$setFieldThe $setField operator sets or updates the value of a field in a document.
Expand table
Description
$elemMatchThe $elemMatch projection operator limits the contents of an array field from the query results to contain only those array elements that match the specified query condition.
$metaThe $meta projection operator returns metadata about the query, such as the text score.
$sliceThe $slice projection operator limits the number of elements projected from an array field.