| NewDocumentDB 1.0 is here. See what's new → | https://documentdb.github.io/v1/ |
| DocumentDB | https://documentdb.github.io/ |
| Docs | https://documentdb.github.io/docs/ |
| Install & Download | https://documentdb.github.io/packages/ |
| AI | https://documentdb.github.io/ai/ |
| Kubernetes | https://documentdb.github.io/kubernetes-operator/ |
| Samples | https://documentdb.github.io/samples/ |
| VS Code extension | https://marketplace.visualstudio.com/items?itemName=ms-azuretools.vscode-documentdb |
| Agent-Kit | https://github.com/Azure/documentdb-agent-kit |
| Announcements | https://documentdb.github.io/announcements/ |
| Blogs | https://documentdb.github.io/blogs/ |
| GitHub | https://github.com/documentdb/documentdb |
| Discord | https://discord.gg/vH7bYu524D |
| Back to Documentation | https://documentdb.github.io/docs/ |
| MQL Documentation | https://documentdb.github.io/docs/reference/ |
| Commands | https://documentdb.github.io/docs/reference/commands/ |
| Administration | https://documentdb.github.io/docs/reference/commands/administration/ |
| Aggregation | https://documentdb.github.io/docs/reference/commands/aggregation/ |
| Diagnostic | https://documentdb.github.io/docs/reference/commands/diagnostic/ |
| Documentdb Distributed | https://documentdb.github.io/docs/reference/commands/documentdb_distributed/ |
| Indexing | https://documentdb.github.io/docs/reference/commands/indexing/ |
| Query And Write | https://documentdb.github.io/docs/reference/commands/query-and-write/ |
| Security | https://documentdb.github.io/docs/reference/commands/security/ |
| Sessions | https://documentdb.github.io/docs/reference/commands/sessions/ |
| Sharding | https://documentdb.github.io/docs/reference/commands/sharding/ |
| Operators | https://documentdb.github.io/docs/reference/operators/ |
| Accumulators | https://documentdb.github.io/docs/reference/operators/accumulators/ |
| Aggregation | https://documentdb.github.io/docs/reference/operators/aggregation/ |
| Arithmetic Expression | https://documentdb.github.io/docs/reference/operators/arithmetic-expression/ |
| Array Expression | https://documentdb.github.io/docs/reference/operators/array-expression/ |
| Array Query | https://documentdb.github.io/docs/reference/operators/array-query/ |
| Array Update | https://documentdb.github.io/docs/reference/operators/array-update/ |
| Bitwise | https://documentdb.github.io/docs/reference/operators/bitwise/ |
| Bitwise Query | https://documentdb.github.io/docs/reference/operators/bitwise-query/ |
| Bitwise Update | https://documentdb.github.io/docs/reference/operators/bitwise-update/ |
| Comparison Query | https://documentdb.github.io/docs/reference/operators/comparison-query/ |
| Conditional Expression | https://documentdb.github.io/docs/reference/operators/conditional-expression/ |
| Data Size | https://documentdb.github.io/docs/reference/operators/data-size/ |
| Date Expression | https://documentdb.github.io/docs/reference/operators/date-expression/ |
| Element Query | https://documentdb.github.io/docs/reference/operators/element-query/ |
| Evaluation Query | https://documentdb.github.io/docs/reference/operators/evaluation-query/ |
| Field Update | https://documentdb.github.io/docs/reference/operators/field-update/ |
| Geospatial | https://documentdb.github.io/docs/reference/operators/geospatial/ |
| Literal Expression | https://documentdb.github.io/docs/reference/operators/literal-expression/ |
| Logical Query | https://documentdb.github.io/docs/reference/operators/logical-query/ |
| Miscellaneous | https://documentdb.github.io/docs/reference/operators/miscellaneous/ |
| Miscellaneous Query | https://documentdb.github.io/docs/reference/operators/miscellaneous-query/ |
| Object Expression | https://documentdb.github.io/docs/reference/operators/object-expression/ |
| Projection | https://documentdb.github.io/docs/reference/operators/projection/ |
| Set Expression | https://documentdb.github.io/docs/reference/operators/set-expression/ |
| Timestamp Expression | https://documentdb.github.io/docs/reference/operators/timestamp-expression/ |
| Variable Expression | https://documentdb.github.io/docs/reference/operators/variable-expression/ |
| Window Operators | https://documentdb.github.io/docs/reference/operators/window-operators/ |
| Commands | https://documentdb.github.io/docs/reference/commands/ |
| Administration | https://documentdb.github.io/docs/reference/commands/administration/ |
| Aggregation | https://documentdb.github.io/docs/reference/commands/aggregation/ |
| Diagnostic | https://documentdb.github.io/docs/reference/commands/diagnostic/ |
| Documentdb Distributed | https://documentdb.github.io/docs/reference/commands/documentdb_distributed/ |
| Indexing | https://documentdb.github.io/docs/reference/commands/indexing/ |
| Query And Write | https://documentdb.github.io/docs/reference/commands/query-and-write/ |
| Security | https://documentdb.github.io/docs/reference/commands/security/ |
| Sessions | https://documentdb.github.io/docs/reference/commands/sessions/ |
| Sharding | https://documentdb.github.io/docs/reference/commands/sharding/ |
| Operators | https://documentdb.github.io/docs/reference/operators/ |
| Accumulators | https://documentdb.github.io/docs/reference/operators/accumulators/ |
| Aggregation | https://documentdb.github.io/docs/reference/operators/aggregation/ |
| Arithmetic Expression | https://documentdb.github.io/docs/reference/operators/arithmetic-expression/ |
| Array Expression | https://documentdb.github.io/docs/reference/operators/array-expression/ |
| Array Query | https://documentdb.github.io/docs/reference/operators/array-query/ |
| Array Update | https://documentdb.github.io/docs/reference/operators/array-update/ |
| Bitwise | https://documentdb.github.io/docs/reference/operators/bitwise/ |
| Bitwise Query | https://documentdb.github.io/docs/reference/operators/bitwise-query/ |
| Bitwise Update | https://documentdb.github.io/docs/reference/operators/bitwise-update/ |
| Comparison Query | https://documentdb.github.io/docs/reference/operators/comparison-query/ |
| Conditional Expression | https://documentdb.github.io/docs/reference/operators/conditional-expression/ |
| Data Size | https://documentdb.github.io/docs/reference/operators/data-size/ |
| Date Expression | https://documentdb.github.io/docs/reference/operators/date-expression/ |
| Element Query | https://documentdb.github.io/docs/reference/operators/element-query/ |
| Evaluation Query | https://documentdb.github.io/docs/reference/operators/evaluation-query/ |
| Field Update | https://documentdb.github.io/docs/reference/operators/field-update/ |
| Geospatial | https://documentdb.github.io/docs/reference/operators/geospatial/ |
| Literal Expression | https://documentdb.github.io/docs/reference/operators/literal-expression/ |
| Logical Query | https://documentdb.github.io/docs/reference/operators/logical-query/ |
| Miscellaneous | https://documentdb.github.io/docs/reference/operators/miscellaneous/ |
| Miscellaneous Query | https://documentdb.github.io/docs/reference/operators/miscellaneous-query/ |
| Object Expression | https://documentdb.github.io/docs/reference/operators/object-expression/ |
| Projection | https://documentdb.github.io/docs/reference/operators/projection/ |
| Set Expression | https://documentdb.github.io/docs/reference/operators/set-expression/ |
| Timestamp Expression | https://documentdb.github.io/docs/reference/operators/timestamp-expression/ |
| Variable Expression | https://documentdb.github.io/docs/reference/operators/variable-expression/ |
| Window Operators | https://documentdb.github.io/docs/reference/operators/window-operators/ |
| Reference | https://documentdb.github.io/docs/reference/ |
| Operators | https://documentdb.github.io/docs/reference/operators/ |
| Accumulators | https://documentdb.github.io/docs/reference/operators/accumulators/ |
| $avgThe $avg operator computes the average of numeric values for documents in a group, bucket, or window. | https://documentdb.github.io/docs/reference/operators/accumulators/$avg/ |
| $bottomThe $bottom operator returns the last document from the query's result set sorted by one or more fields | https://documentdb.github.io/docs/reference/operators/accumulators/$bottom/ |
| $bottomNThe $bottomN operator returns the last N documents from the result sorted by one or more fields | https://documentdb.github.io/docs/reference/operators/accumulators/$bottomn/ |
| $countThe `$count` operator is used to count the number of documents that match a query filtering criteria. | https://documentdb.github.io/docs/reference/operators/accumulators/$count/ |
| $firstThe $first operator returns the first value in a group according to the group's sorting order. | https://documentdb.github.io/docs/reference/operators/accumulators/$first/ |
| $firstNThe $firstN operator sorts documents on one or more fields specified by the query and returns the first N document matching the filtering criteria | https://documentdb.github.io/docs/reference/operators/accumulators/$firstn/ |
| $lastThe $last operator returns the last document from the result sorted by one or more fields | https://documentdb.github.io/docs/reference/operators/accumulators/$last/ |
| $lastNThe $lastN accumulator operator returns the last N values in a group of documents. | https://documentdb.github.io/docs/reference/operators/accumulators/$lastn/ |
| $maxThe $max operator returns the maximum value from a set of input values. | https://documentdb.github.io/docs/reference/operators/accumulators/$max/ |
| $maxNThe $maxN opertor retrieves the top N values based on a specified filtering criteria | https://documentdb.github.io/docs/reference/operators/accumulators/$maxn/ |
| $medianThe $median operator calculates the median value of a numeric field in a group of documents. | https://documentdb.github.io/docs/reference/operators/accumulators/$median/ |
| $minThe $min operator retrieves the minimum value for a specified field | https://documentdb.github.io/docs/reference/operators/accumulators/$min/ |
| $minNThe $minN operator retrieves the bottom N values based on a specified filtering criteria | https://documentdb.github.io/docs/reference/operators/accumulators/$minn/ |
| $percentileThe $percentile operator calculates the percentile of numerical values that match a filtering criteria | https://documentdb.github.io/docs/reference/operators/accumulators/$percentile/ |
| $stddevpopThe $stddevpop operator calculates the standard deviation of the specified values | https://documentdb.github.io/docs/reference/operators/accumulators/$stddevpop/ |
| $stddevsampThe $stddevsamp operator calculates the standard deviation of a specified sample of values and not the entire population | https://documentdb.github.io/docs/reference/operators/accumulators/$stddevsamp/ |
| $sumThe $sum operator calculates the sum of the values of a field based on a filtering criteria | https://documentdb.github.io/docs/reference/operators/accumulators/$sum/ |
| $topThe $top operator returns the first document from the result set sorted by one or more fields | https://documentdb.github.io/docs/reference/operators/accumulators/$top/ |
| $topNThe $topN operator returns the first N documents from the result sorted by one or more fields | https://documentdb.github.io/docs/reference/operators/accumulators/$topn/ |
| Aggregation | https://documentdb.github.io/docs/reference/operators/aggregation/ |
| $addFieldsThe $addFields stage in the aggregation pipeline is used to add new fields to documents. | https://documentdb.github.io/docs/reference/operators/aggregation/$addfields/ |
| $bucketThe $bucket operator groups input documents into buckets based on specified boundaries. | https://documentdb.github.io/docs/reference/operators/aggregation/$bucket/ |
| $bucketAutoThe $bucketAuto stage automatically distributes documents into a specified number of buckets based on a grouping expression. | https://documentdb.github.io/docs/reference/operators/aggregation/$bucketauto/ |
| $changeStreamThe $changeStream stage opens a change stream cursor in MongoDB. DocumentDB does not support it. | https://documentdb.github.io/docs/reference/operators/aggregation/$changestream/ |
| $collStatsThe $collStats stage in the aggregation pipeline is used to return statistics about a collection. | https://documentdb.github.io/docs/reference/operators/aggregation/$collstats/ |
| $convertThe $convert operator converts an expression into the specified type | https://documentdb.github.io/docs/reference/operators/aggregation/$convert/ |
| $currentOpThe $currentOp stage returns information on active and queued operations for the database. | https://documentdb.github.io/docs/reference/operators/aggregation/$currentop/ |
| $densifyThe $densify operator adds missing data points in a sequence of values within an array or collection. | https://documentdb.github.io/docs/reference/operators/aggregation/$densify/ |
| $documentsThe $documents stage creates a pipeline from a set of provided documents. | https://documentdb.github.io/docs/reference/operators/aggregation/$documents/ |
| $facetThe $facet allows for multiple parallel aggregations to be executed within a single pipeline stage. | https://documentdb.github.io/docs/reference/operators/aggregation/$facet/ |
| $fillThe $fill stage allows filling missing values in documents based on specified methods and criteria. | https://documentdb.github.io/docs/reference/operators/aggregation/$fill/ |
| $geoNearThe $geoNear operator finds and sorts documents by their proximity to a geospatial point, returning distance information for each document. | https://documentdb.github.io/docs/reference/operators/aggregation/$geonear/ |
| $graphLookupThe $graphLookup stage in the aggregation pipeline performs a recursive search across documents in a collection. | https://documentdb.github.io/docs/reference/operators/aggregation/$graphlookup/ |
| $groupThe $group stage groups documents by specified identifier expressions and applies accumulator expressions. | https://documentdb.github.io/docs/reference/operators/aggregation/$group/ |
| $indexStatsThe $indexStats stage returns usage statistics for each index in the collection. | https://documentdb.github.io/docs/reference/operators/aggregation/$indexstats/ |
| $inverseMatchThe $inverseMatch stage in the aggregation pipeline keeps documents whose stored query matches a supplied document, inverting the usual direction of a match. | https://documentdb.github.io/docs/reference/operators/aggregation/$inversematch/ |
| $isNumberThe $isNumber operator checks if a specified expression is a numerical type | https://documentdb.github.io/docs/reference/operators/aggregation/$isnumber/ |
| $limitThe $limit stage in the aggregation pipeline restricts the number of documents passed to the next stage. | https://documentdb.github.io/docs/reference/operators/aggregation/$limit/ |
| $lookupThe $lookup stage in the Aggregation Framework is used to perform left outer joins with other collections. | https://documentdb.github.io/docs/reference/operators/aggregation/$lookup/ |
| $matchThe $match stage in the aggregation pipeline is used to filter documents that match a specified condition. | https://documentdb.github.io/docs/reference/operators/aggregation/$match/ |
| $mergeThe $merge stage in an aggregation pipeline writes the results of the aggregation to a specified collection. | https://documentdb.github.io/docs/reference/operators/aggregation/$merge/ |
| $outThe `$out` stage in an aggregation pipeline writes the resulting documents to a specified collection. | https://documentdb.github.io/docs/reference/operators/aggregation/$out/ |
| $projectThe $project stage in the aggregation pipeline reshapes documents by including, excluding, or computing fields. | https://documentdb.github.io/docs/reference/operators/aggregation/$project/ |
| $redactThe $redact operator filters the content of the documents based on access rights. | https://documentdb.github.io/docs/reference/operators/aggregation/$redact/ |
| $replaceRootThe $replaceRoot stage replaces the input document with the specified document. | https://documentdb.github.io/docs/reference/operators/aggregation/$replaceroot/ |
| $replaceWithThe $replaceWith operator in DocumentDB returns a document after replacing a document with the specified document | https://documentdb.github.io/docs/reference/operators/aggregation/$replacewith/ |
| $sampleThe $sample operator in DocumentDB returns a randomly selected number of documents | https://documentdb.github.io/docs/reference/operators/aggregation/$sample/ |
| $searchThe $search stage in the aggregation pipeline runs a vector similarity search through the cosmosSearch or knnBeta operator. | https://documentdb.github.io/docs/reference/operators/aggregation/$search/ |
| $setThe $set operator in DocumentDB updates or creates a new field with a specified value | https://documentdb.github.io/docs/reference/operators/aggregation/$set/ |
| $setWindowFieldsThe $setWindowFields stage performs operations on a specified span of documents (a window) and returns results based on the chosen window operator. | https://documentdb.github.io/docs/reference/operators/aggregation/$setwindowfields/ |
| $skipThe $skip stage in the aggregation pipeline is used to skip a specified number of documents from the input and pass the remaining documents to the next stage in the pipeline. | https://documentdb.github.io/docs/reference/operators/aggregation/$skip/ |
| $sortThe $sort stage in the aggregation pipeline is used to order the documents in the pipeline by a specified field or fields. | https://documentdb.github.io/docs/reference/operators/aggregation/$sort/ |
| $sortByCountThe $sortByCount stage in the aggregation pipeline is used to group documents by a specified expression and then sort the count of documents in each group in descending order. | https://documentdb.github.io/docs/reference/operators/aggregation/$sortbycount/ |
| $toBoolThe $toBool operator converts an expression into a Boolean type | https://documentdb.github.io/docs/reference/operators/aggregation/$tobool/ |
| $toDateThe $toDate operator converts supported types to a proper Date object. | https://documentdb.github.io/docs/reference/operators/aggregation/$todate/ |
| $toDecimalThe $toDecimal operator converts an expression into a Decimal type | https://documentdb.github.io/docs/reference/operators/aggregation/$todecimal/ |
| $toDoubleThe $toDouble operator converts an expression into a Double value | https://documentdb.github.io/docs/reference/operators/aggregation/$todouble/ |
| $toIntThe $toInt operator converts an expression into an Integer | https://documentdb.github.io/docs/reference/operators/aggregation/$toint/ |
| $toLongThe $toLong operator converts an expression into a Long value | https://documentdb.github.io/docs/reference/operators/aggregation/$tolong/ |
| $toObjectIdThe $toObjectId operator converts an expression into an ObjectId | https://documentdb.github.io/docs/reference/operators/aggregation/$toobjectid/ |
| $toStringThe $toString operator converts an expression into a String | https://documentdb.github.io/docs/reference/operators/aggregation/$tostring/ |
| $unionWithThe $unionWith stage performs a union of two collections, combining pipeline results from two collections into a single result set. | https://documentdb.github.io/docs/reference/operators/aggregation/$unionwith/ |
| $unsetThe $unset stage in the aggregation pipeline is used to remove specified fields from documents. | https://documentdb.github.io/docs/reference/operators/aggregation/$unset/ |
| $unwindThe $unwind stage in the aggregation framework is used to deconstruct an array field from the input documents to output a document for each element. | https://documentdb.github.io/docs/reference/operators/aggregation/$unwind/ |
| $vectorSearchThe $vectorSearch stage in the aggregation pipeline runs an approximate nearest-neighbor search over a vector index. | https://documentdb.github.io/docs/reference/operators/aggregation/$vectorsearch/ |
| Arithmetic Expression | https://documentdb.github.io/docs/reference/operators/arithmetic-expression/ |
| $absThe $abs operator returns the absolute value of a number. | https://documentdb.github.io/docs/reference/operators/arithmetic-expression/$abs/ |
| $addThe $add operator returns the sum of two numbers or the sum of a date and numbers. | https://documentdb.github.io/docs/reference/operators/arithmetic-expression/$add/ |
| $ceilThe $ceil operator returns the smallest integer greater than or equal to the specified number. | https://documentdb.github.io/docs/reference/operators/arithmetic-expression/$ceil/ |
| $divideThe $divide operator divides two numbers and returns the quotient. | https://documentdb.github.io/docs/reference/operators/arithmetic-expression/$divide/ |
| $expThe $exp operator raises e to the specified exponent and returns the result | https://documentdb.github.io/docs/reference/operators/arithmetic-expression/$exp/ |
| $floorThe $floor operator returns the largest integer less than or equal to the specified number | https://documentdb.github.io/docs/reference/operators/arithmetic-expression/$floor/ |
| $lnThe $ln operator calculates the natural logarithm of the input | https://documentdb.github.io/docs/reference/operators/arithmetic-expression/$ln/ |
| $logThe $log operator calculates the logarithm of a number in the specified base | https://documentdb.github.io/docs/reference/operators/arithmetic-expression/$log/ |
| $log10The $log10 operator calculates the log of a specified number in base 10 | https://documentdb.github.io/docs/reference/operators/arithmetic-expression/$log10/ |
| $multiplyThe $multiply operator multiplies the input numerical values | https://documentdb.github.io/docs/reference/operators/arithmetic-expression/$multiply/ |
| $powThe `$pow` operator calculates the value of a numerical value raised to the power of a specified exponent. | https://documentdb.github.io/docs/reference/operators/arithmetic-expression/$pow/ |
| $roundThe $round operator rounds a number to a specified decimal place. | https://documentdb.github.io/docs/reference/operators/arithmetic-expression/$round/ |
| $sqrtThe $sqrt operator calculates and returns the square root of an input number | https://documentdb.github.io/docs/reference/operators/arithmetic-expression/$sqrt/ |
| $subtractThe $subtract operator subtracts two numbers and returns the result. | https://documentdb.github.io/docs/reference/operators/arithmetic-expression/$subtract/ |
| $truncThe $trunc operator truncates a number to a specified decimal place. | https://documentdb.github.io/docs/reference/operators/arithmetic-expression/$trunc/ |
| Array Expression | https://documentdb.github.io/docs/reference/operators/array-expression/ |
| $arrayElemAtThe $arrayElemAt returns the element at the specified array index. | https://documentdb.github.io/docs/reference/operators/array-expression/$arrayelemat/ |
| $arrayToObjectThe $arrayToObject allows converting an array into a single document. | https://documentdb.github.io/docs/reference/operators/array-expression/$arraytoobject/ |
| $concatArraysThe $concatArrays is used to combine multiple arrays into a single array. | https://documentdb.github.io/docs/reference/operators/array-expression/$concatarrays/ |
| $filterThe $filter operator filters for elements from an array based on a specified condition. | https://documentdb.github.io/docs/reference/operators/array-expression/$filter/ |
| $indexOfArrayThe $indexOfArray operator is used to search for an element in an array and return the index of the first occurrence of the element. | https://documentdb.github.io/docs/reference/operators/array-expression/$indexofarray/ |
| $isArrayThe $isArray operator is used to determine if a specified value is an array. | https://documentdb.github.io/docs/reference/operators/array-expression/$isarray/ |
| $mapThe $map operator allows applying an expression to each element in an array. | https://documentdb.github.io/docs/reference/operators/array-expression/$map/ |
| $rangeThe $range operator allows generating an array of sequential integers. | https://documentdb.github.io/docs/reference/operators/array-expression/$range/ |
| $reduceThe $reduce operator applies an expression to each element in an array & accumulate result as single value. | https://documentdb.github.io/docs/reference/operators/array-expression/$reduce/ |
| $reverseArrayThe $reverseArray operator is used to reverse the order of elements in an array. | https://documentdb.github.io/docs/reference/operators/array-expression/$reversearray/ |
| $sliceThe $slice operator returns a subset of an array from any element onwards in the array. | https://documentdb.github.io/docs/reference/operators/array-expression/$slice/ |
| $sortArrayThe $sortArray operator helps in sorting the elements in an array. | https://documentdb.github.io/docs/reference/operators/array-expression/$sortarray/ |
| $zipThe $zip operator allows merging two or more arrays element-wise into a single array or arrays. | https://documentdb.github.io/docs/reference/operators/array-expression/$zip/ |
| Array Query | https://documentdb.github.io/docs/reference/operators/array-query/ |
| $allThe $all operator helps finding array documents matching all the elements. | https://documentdb.github.io/docs/reference/operators/array-query/$all/ |
| $elemMatchThe $elemMatch operator returns complete array, qualifying criteria with at least one matching array element. | https://documentdb.github.io/docs/reference/operators/array-query/$elemmatch/ |
| $sizeThe $size operator is used to query documents where an array field has a specified number of elements. | https://documentdb.github.io/docs/reference/operators/array-query/$size/ |
| Array Update | https://documentdb.github.io/docs/reference/operators/array-update/ |
| $The $ positional operator identifies an element in an array to update without explicitly specifying the position of the element in the array. | https://documentdb.github.io/docs/reference/operators/array-update/$/ |
| $addToSetThe addToSet operator adds elements to an array if they don't already exist, while ensuring uniqueness of elements within the set. | https://documentdb.github.io/docs/reference/operators/array-update/$addtoset/ |
| $eachThe $each operator is used within an `$addToSet` or `$push` operation to add multiple elements to an array field in a single update operation. | https://documentdb.github.io/docs/reference/operators/array-update/$each/ |
| $popThe $pop operator removes the first or last element of an array. | https://documentdb.github.io/docs/reference/operators/array-update/$pop/ |
| $[]The $[] all positional operator applies an update to every element of an array. | https://documentdb.github.io/docs/reference/operators/array-update/$positional-all/ |
| $[identifier]The $[identifier] operator is used to update all elements using a specific identifier in an array that match the query condition. | https://documentdb.github.io/docs/reference/operators/array-update/$positional-filtered/ |
| $positionThe $position is used to specify the position in the array where a new element should be inserted. | https://documentdb.github.io/docs/reference/operators/array-update/$positional/ |
| $pullRemoves all instances of a value from an array. | https://documentdb.github.io/docs/reference/operators/array-update/$pull/ |
| $pullAllThe $pullAll operator is used to remove all instances of the specified values from an array. | https://documentdb.github.io/docs/reference/operators/array-update/$pullall/ |
| $pushThe $push operator adds a specified value to an array within a document. | https://documentdb.github.io/docs/reference/operators/array-update/$push/ |
| Bitwise | https://documentdb.github.io/docs/reference/operators/bitwise/ |
| $bitAndThe $bitAnd operator performs a bitwise AND operation on integer values and returns the result as an integer. | https://documentdb.github.io/docs/reference/operators/bitwise/$bitand/ |
| $bitNotThe $bitNot operator performs a bitwise NOT operation on integer values and returns the result as an integer. | https://documentdb.github.io/docs/reference/operators/bitwise/$bitnot/ |
| $bitOrThe $bitOr operator performs a bitwise OR operation on integer values and returns the result as an integer. | https://documentdb.github.io/docs/reference/operators/bitwise/$bitor/ |
| $bitXorThe $bitXor operator performs a bitwise XOR operation on integer values. | https://documentdb.github.io/docs/reference/operators/bitwise/$bitxor/ |
| Bitwise Query | https://documentdb.github.io/docs/reference/operators/bitwise-query/ |
| $bitsAllClearThe $bitsAllClear operator is used to match documents where all the bit positions specified in a bitmask are clear. | https://documentdb.github.io/docs/reference/operators/bitwise-query/$bitsAllClear/ |
| $bitsAllSetThe bitsAllSet command is used to match documents where all the specified bit positions are set. | https://documentdb.github.io/docs/reference/operators/bitwise-query/$bitsAllSet/ |
| $bitsAnyClearThe $bitsAnyClear operator matches documents where any of the specified bit positions in a bitmask are clear. | https://documentdb.github.io/docs/reference/operators/bitwise-query/$bitsAnyClear/ |
| $bitsAnySetThe $bitsAnySet operator returns documents where any of the specified bit positions are set to 1. | https://documentdb.github.io/docs/reference/operators/bitwise-query/$bitsAnySet/ |
| Bitwise Update | https://documentdb.github.io/docs/reference/operators/bitwise-update/ |
| $bitThe `$bit` operator is used to perform bitwise operations on integer values. | https://documentdb.github.io/docs/reference/operators/bitwise-update/$bit/ |
| Comparison Query | https://documentdb.github.io/docs/reference/operators/comparison-query/ |
| $cmpThe $cmp operator compares two values | https://documentdb.github.io/docs/reference/operators/comparison-query/$cmp/ |
| $eqThe $eq query operator compares the value of a field to a specified value | https://documentdb.github.io/docs/reference/operators/comparison-query/$eq/ |
| $gtThe $gt query operator retrieves documents where the value of a field is greater than a specified value | https://documentdb.github.io/docs/reference/operators/comparison-query/$gt/ |
| $gteThe $gte operator retrieves documents where the value of a field is greater than or equal to a specified value | https://documentdb.github.io/docs/reference/operators/comparison-query/$gte/ |
| $inThe $in operator matches value of a field against an array of specified values | https://documentdb.github.io/docs/reference/operators/comparison-query/$in/ |
| $ltThe $lt operator retrieves documents where the value of field is less than a specified value | https://documentdb.github.io/docs/reference/operators/comparison-query/$lt/ |
| $lteThe $lte operator retrieves documents where the value of a field is less than or equal to a specified value | https://documentdb.github.io/docs/reference/operators/comparison-query/$lte/ |
| $neThe $ne operator retrieves documents where the value of a field doesn't equal a specified value | https://documentdb.github.io/docs/reference/operators/comparison-query/$ne/ |
| $ninThe $nin operator retrieves documents where the value of a field doesn't match a list of values | https://documentdb.github.io/docs/reference/operators/comparison-query/$nin/ |
| Conditional Expression | https://documentdb.github.io/docs/reference/operators/conditional-expression/ |
| $condThe $cond operator is used to evaluate a condition and return one of two expressions based on the result. | https://documentdb.github.io/docs/reference/operators/conditional-expression/$cond/ |
| $ifNullThe $ifNull operator is used to evaluate an expression and return a specified value if the expression resolves to null. | https://documentdb.github.io/docs/reference/operators/conditional-expression/$ifnull/ |
| $switchThe $switch operator is used to evaluate a series of conditions and return a value based on the first condition that evaluates to true. | https://documentdb.github.io/docs/reference/operators/conditional-expression/$switch/ |
| Data Size | https://documentdb.github.io/docs/reference/operators/data-size/ |
| $binarySizeThe $binarySize operator is used to return the size of a binary data field. | https://documentdb.github.io/docs/reference/operators/data-size/$binarysize/ |
| $bsonSizeThe $bsonSize operator returns the size of a document in bytes when encoded as BSON. | https://documentdb.github.io/docs/reference/operators/data-size/$bsonsize/ |
| Date Expression | https://documentdb.github.io/docs/reference/operators/date-expression/ |
| $dateAddThe $dateAdd operator adds a specified number of time units (day, hour, month etc) to a date. | https://documentdb.github.io/docs/reference/operators/date-expression/$dateadd/ |
| $dateDiffThe $dateDiff operator calculates the difference between two dates in various units such as years, months, days, etc. | https://documentdb.github.io/docs/reference/operators/date-expression/$datediff/ |
| $dateFromPartsThe $dateFromParts operator constructs a date from individual components. | https://documentdb.github.io/docs/reference/operators/date-expression/$datefromparts/ |
| $dateFromStringThe $dateDiff operator converts a date/time string to a date object. | https://documentdb.github.io/docs/reference/operators/date-expression/$datefromstring/ |
| $dateSubtractThe $dateSubtract operator subtracts a specified amount of time from a date. | https://documentdb.github.io/docs/reference/operators/date-expression/$datesubtract/ |
| $dateToPartsThe $dateToParts operator decomposes a date into its individual parts such as year, month, day, and more. | https://documentdb.github.io/docs/reference/operators/date-expression/$datetoparts/ |
| $dateToStringThe $dateToString operator converts a date object into a formatted string. | https://documentdb.github.io/docs/reference/operators/date-expression/$datetostring/ |
| $dateTruncThe $dateTrunc operator truncates a date to a specified unit. | https://documentdb.github.io/docs/reference/operators/date-expression/$datetrunc/ |
| $dayOfMonthThe $dayOfMonth operator extracts the day of the month from a date. | https://documentdb.github.io/docs/reference/operators/date-expression/$dayofmonth/ |
| $dayOfWeekThe $dayOfWeek operator extracts the day of the week from a date. | https://documentdb.github.io/docs/reference/operators/date-expression/$dayofweek/ |
| $dayOfYearThe $dayOfYear operator extracts the day of the year from a date. | https://documentdb.github.io/docs/reference/operators/date-expression/$dayofyear/ |
| $hourThe $hour operator returns the hour portion of a date as a number between 0 and 23. | https://documentdb.github.io/docs/reference/operators/date-expression/$hour/ |
| $isoDayOfWeekThe $isoDayOfWeek operator returns the weekday number in ISO 8601 format, ranging from 1 (Monday) to 7 (Sunday). | https://documentdb.github.io/docs/reference/operators/date-expression/$isodayofweek/ |
| $isoWeekThe $isoWeek operator returns the week number of the year in ISO 8601 format, ranging from 1 to 53. | https://documentdb.github.io/docs/reference/operators/date-expression/$isoweek/ |
| $isoWeekYearThe $isoWeekYear operator returns the year number in ISO 8601 format, which can differ from the calendar year for dates at the beginning or end of the year. | https://documentdb.github.io/docs/reference/operators/date-expression/$isoweekyear/ |
| $millisecondThe $millisecond operator extracts the milliseconds portion from a date value. | https://documentdb.github.io/docs/reference/operators/date-expression/$millisecond/ |
| $minuteThe $minute operator extracts the minute portion from a date value. | https://documentdb.github.io/docs/reference/operators/date-expression/$minute/ |
| $monthThe $month operator extracts the month portion from a date value. | https://documentdb.github.io/docs/reference/operators/date-expression/$month/ |
| $secondThe $second operator extracts the seconds portion from a date value. | https://documentdb.github.io/docs/reference/operators/date-expression/$second/ |
| $weekThe $week operator returns the week number for a date as a value between 0 and 53. | https://documentdb.github.io/docs/reference/operators/date-expression/$week/ |
| $yearThe $year operator returns the year for a date as a four-digit number. | https://documentdb.github.io/docs/reference/operators/date-expression/$year/ |
| Element Query | https://documentdb.github.io/docs/reference/operators/element-query/ |
| $existsThe $exists operator retrieves documents that contain the specified field in their document structure. | https://documentdb.github.io/docs/reference/operators/element-query/$exists/ |
| $typeThe $type operator retrieves documents if the chosen field is of the specified type. | https://documentdb.github.io/docs/reference/operators/element-query/$type/ |
| Evaluation Query | https://documentdb.github.io/docs/reference/operators/evaluation-query/ |
| $exprThe $expr operator allows the use of aggregation expressions within the query language, enabling complex field comparisons and calculations. | https://documentdb.github.io/docs/reference/operators/evaluation-query/$expr/ |
| $jsonSchemaThe $jsonSchema operator validates documents against a JSON Schema definition for data validation and structure enforcement. Discover supported features and limitations. | https://documentdb.github.io/docs/reference/operators/evaluation-query/$jsonschema/ |
| $modThe $mod operator performs a modulo operation on the value of a field and selects documents with a specified result. | https://documentdb.github.io/docs/reference/operators/evaluation-query/$mod/ |
| $regexThe $regex operator provides regular expression capabilities for pattern matching in queries, allowing flexible string matching and searching. | https://documentdb.github.io/docs/reference/operators/evaluation-query/$regex/ |
| $textThe $text operator performs text search on the content of indexed string fields, enabling full-text search capabilities. | https://documentdb.github.io/docs/reference/operators/evaluation-query/$text/ |
| Field Update | https://documentdb.github.io/docs/reference/operators/field-update/ |
| $currentDateThe $currentDate operator sets the value of a field to the current date, either as a Date or a timestamp. | https://documentdb.github.io/docs/reference/operators/field-update/$currentdate/ |
| $incThe $inc operator increments the value of a field by a specified amount. | https://documentdb.github.io/docs/reference/operators/field-update/$inc/ |
| $mulThe $mul operator multiplies the value of a field by a specified number. | https://documentdb.github.io/docs/reference/operators/field-update/$mul/ |
| $renameThe $rename operator allows renaming fields in documents during update operations. | https://documentdb.github.io/docs/reference/operators/field-update/$rename/ |
| $setOnInsertThe $setOnInsert operator sets field values only when an upsert operation results in an insert of a new document. | https://documentdb.github.io/docs/reference/operators/field-update/$setoninsert/ |
| Geospatial | https://documentdb.github.io/docs/reference/operators/geospatial/ |
| $boxThe $box operator defines a rectangular area for geospatial queries using coordinate pairs. | https://documentdb.github.io/docs/reference/operators/geospatial/$box/ |
| $centerThe $center operator specifies a circle using legacy coordinate pairs for $geoWithin queries. | https://documentdb.github.io/docs/reference/operators/geospatial/$center/ |
| $centerSphereThe $centerSphere operator specifies a circle using spherical geometry for $geoWithin queries. | https://documentdb.github.io/docs/reference/operators/geospatial/$centersphere/ |
| $geoIntersectsThe $geoIntersects operator selects documents whose location field intersects with a specified GeoJSON object. | https://documentdb.github.io/docs/reference/operators/geospatial/$geointersects/ |
| $geometryThe $geometry operator specifies a GeoJSON geometry for geospatial queries. | https://documentdb.github.io/docs/reference/operators/geospatial/$geometry/ |
| $geoWithinThe $geoWithin operator selects documents whose location field is completely within a specified geometry. | https://documentdb.github.io/docs/reference/operators/geospatial/$geowithin/ |
| $maxDistanceThe $maxDistance operator specifies the maximum distance that can exist between two points in a geospatial query. | https://documentdb.github.io/docs/reference/operators/geospatial/$maxdistance/ |
| $minDistanceThe $minDistance operator specifies the minimum distance that must exist between two points in a geospatial query. | https://documentdb.github.io/docs/reference/operators/geospatial/$mindistance/ |
| $nearThe $near operator returns documents with location fields that are near a specified point, sorted by distance. | https://documentdb.github.io/docs/reference/operators/geospatial/$near/ |
| $nearSphereThe $nearSphere operator returns documents whose location fields are near a specified point on a sphere, sorted by distance on a spherical surface. | https://documentdb.github.io/docs/reference/operators/geospatial/$nearsphere/ |
| $polygonThe $polygon operator defines a polygon for geospatial queries, allowing you to find locations within an irregular shape. | https://documentdb.github.io/docs/reference/operators/geospatial/$polygon/ |
| Literal Expression | https://documentdb.github.io/docs/reference/operators/literal-expression/ |
| $literalThe $literal operator returns the specified value without parsing it as an expression, allowing literal values to be used in aggregation pipelines. | https://documentdb.github.io/docs/reference/operators/literal-expression/$literal/ |
| Logical Query | https://documentdb.github.io/docs/reference/operators/logical-query/ |
| $andThe $and operator joins multiple query clauses and returns documents that match all specified conditions. | https://documentdb.github.io/docs/reference/operators/logical-query/$and/ |
| $norThe $nor operator performs a logical NOR on an array of expressions and retrieves documents that fail all the conditions. | https://documentdb.github.io/docs/reference/operators/logical-query/$nor/ |
| $notThe $not operator performs a logical NOT operation on a specified expression, selecting documents that don't match the expression. | https://documentdb.github.io/docs/reference/operators/logical-query/$not/ |
| $orThe $or operator joins query clauses with a logical OR and returns documents that match at least one of the specified conditions. | https://documentdb.github.io/docs/reference/operators/logical-query/$or/ |
| Miscellaneous | https://documentdb.github.io/docs/reference/operators/miscellaneous/ |
| $getFieldThe $getField operator allows retrieving the value of a specified field from a document. | https://documentdb.github.io/docs/reference/operators/miscellaneous/$getfield/ |
| $sampleRateThe $sampleRate operator randomly samples documents from a collection based on a specified probability rate, useful for statistical analysis and testing. | https://documentdb.github.io/docs/reference/operators/miscellaneous/$samplerate/ |
| Miscellaneous Query | https://documentdb.github.io/docs/reference/operators/miscellaneous-query/ |
| $commentThe $comment operator adds a comment to a query to help identify the query in logs and profiler output. | https://documentdb.github.io/docs/reference/operators/miscellaneous-query/$comment/ |
| $naturalThe $natural operator forces the query to use the natural order of documents in a collection, providing control over document ordering and retrieval. | https://documentdb.github.io/docs/reference/operators/miscellaneous-query/$natural/ |
| $randThe $rand operator generates a random float value between 0 and 1. | https://documentdb.github.io/docs/reference/operators/miscellaneous-query/$rand/ |
| Object Expression | https://documentdb.github.io/docs/reference/operators/object-expression/ |
| $mergeObjectsThe $mergeObjects operator merges multiple documents into a single document | https://documentdb.github.io/docs/reference/operators/object-expression/$mergeobjects/ |
| $objectToArrayThe objectToArray command is used to transform a document (object) into an array of key-value pairs. | https://documentdb.github.io/docs/reference/operators/object-expression/$objectToArray/ |
| $setFieldThe setField command is used to add, update, or remove fields in embedded documents. | https://documentdb.github.io/docs/reference/operators/object-expression/$setField/ |
| Projection | https://documentdb.github.io/docs/reference/operators/projection/ |
| $metaThe $meta operator returns a calculated metadata column with returned dataset. | https://documentdb.github.io/docs/reference/operators/projection/$meta/ |
| Set Expression | https://documentdb.github.io/docs/reference/operators/set-expression/ |
| $allElementsTrueThe $allElementsTrue operator returns true if all elements in an array evaluate to true. | https://documentdb.github.io/docs/reference/operators/set-expression/$allelementstrue/ |
| $anyElementTrueThe $anyElementTrue operator returns true if any element in an array evaluates to a value of true. | https://documentdb.github.io/docs/reference/operators/set-expression/$anyelementtrue/ |
| $setDifferenceThe $setDifference operator returns a set with elements that exist in one set but not in a second set. | https://documentdb.github.io/docs/reference/operators/set-expression/$setdifference/ |
| $setEqualsThe $setEquals operator returns true if two sets have the same distinct elements. | https://documentdb.github.io/docs/reference/operators/set-expression/$setequals/ |
| $setIntersectionThe $setIntersection operator returns the common elements that appear in all input arrays. | https://documentdb.github.io/docs/reference/operators/set-expression/$setintersection/ |
| $setIsSubsetThe $setIsSubset operator determines if one array is a subset of a second array. | https://documentdb.github.io/docs/reference/operators/set-expression/$setissubset/ |
| $setUnionThe $setUnion operator returns an array that contains all the unique elements from the input arrays. | https://documentdb.github.io/docs/reference/operators/set-expression/$setunion/ |
| Timestamp Expression | https://documentdb.github.io/docs/reference/operators/timestamp-expression/ |
| $tsIncrementThe $tsIncrement operator extracts the increment portion from a timestamp value. | https://documentdb.github.io/docs/reference/operators/timestamp-expression/$tsincrement/ |
| $tsSecondThe $tsSecond operator extracts the seconds portion from a timestamp value. | https://documentdb.github.io/docs/reference/operators/timestamp-expression/$tssecond/ |
| Variable Expression | https://documentdb.github.io/docs/reference/operators/variable-expression/ |
| $letThe $let operator allows defining variables for use in a specified expression, enabling complex calculations and reducing code repetition. | https://documentdb.github.io/docs/reference/operators/variable-expression/$let/ |
| Window Operators | https://documentdb.github.io/docs/reference/operators/window-operators/ |
| $covariancePopThe $covariancePop operator returns the covariance of two numerical expressions | https://documentdb.github.io/docs/reference/operators/window-operators/$covariancepop/ |
| $covarianceSampThe $covarianceSamp operator returns the covariance of a sample of two numerical expressions | https://documentdb.github.io/docs/reference/operators/window-operators/$covariancesamp/ |
| $denseRankThe $denseRank operator assigns and returns a positional ranking for each document within a partition based on a specified sort order | https://documentdb.github.io/docs/reference/operators/window-operators/$denserank/ |
| $derivativeThe $derivative operator calculates the average rate of change of the value of a field within a specified window. | https://documentdb.github.io/docs/reference/operators/window-operators/$derivative/ |
| $documentNumberThe $documentNumber operator assigns and returns a position for each document within a partition based on a specified sort order | https://documentdb.github.io/docs/reference/operators/window-operators/$documentnumber/ |
| $expMovingAvgThe $expMovingAvg operator calculates the moving average of a field based on the specified number of documents to hold the highest weight | https://documentdb.github.io/docs/reference/operators/window-operators/$expmovingavg/ |
| $integralThe $integral operator calculates the area under a curve with the specified range of documents forming the adjacent documents for the calculation. | https://documentdb.github.io/docs/reference/operators/window-operators/$integral/ |
| $linearFillThe $linearFill operator interpolates missing values in a sequence of documents using linear interpolation. | https://documentdb.github.io/docs/reference/operators/window-operators/$linearfill/ |
| $locfThe $locf operator propagates the last observed non-null value forward within a partition in a windowed query. | https://documentdb.github.io/docs/reference/operators/window-operators/$locf/ |
| $rankThe $rank operator ranks documents within a partition based on a specified sort order. | https://documentdb.github.io/docs/reference/operators/window-operators/$rank/ |
| $shift usage on DocumentDBA window operator that shifts values within a partition and returns the shifted value. | https://documentdb.github.io/docs/reference/operators/window-operators/$shift/ |