Aggregation support
Stages:
- [x] $addFields
- [ ] $bucket
- [ ] $bucketAuto
- [ ] $changeStream
- [ ] $changeStreamSplitLargeEvent
- [ ] $collStats
- [x] $count
- [ ] $currentOp
- [ ] $densify
- [ ] $documents
- [ ] $facet
- [ ] $fill
- [ ] $geoNear
- [ ] $graphLookup
- [x] $group
- [ ] $indexStats
- [x] $limit
- [ ] $listLocalSessions
- [ ] $listSampledQueries
- [ ] $listSearchIndexes
- [ ] $listSessions
- [ ] $lookup
- [x] $match
- [ ] $merge
- [ ] $out
- [ ] $planCacheStats
- [x] $project
- [ ] $querySettings
- [ ] $queryStats
- [ ] $redact
- [ ] $replaceRoot
- [ ] $replaceWith
- [x] $sample
- [ ] $search
- [ ] $searchMeta
- [x] $set
- [ ] $setWindowFields
- [ ] $shardedDataDistribution
- [x] $skip
- [x] $sort
- [ ] $sortByCount
- [x] $unionWith
- [x] $unset
- [ ] $unwind
- [ ] $vectorSearch
Operators:
- [x] $abs
- [ ] $accumulator
- [x] $acos
- [x] $acosh
- [x] $add
- [ ] $addToSet
- [ ] $addToSet (accumulator)
- [ ] $addElementsTrue
- [ ] $and
- [ ] $anyElementTrue
- [ ] $arrayElemAt
- [ ] $arrayToObject
- [x] $asin
- [x] $asinh
- [x] $atan
- [ ] $atan2
- [x] $atanh
- [x] $avg
- [x] $avg (accumulator)
- [ ] $binarySize
- [ ] $bitAnd
- [ ] $bitNot
- [ ] $bitOr
- [ ] $bitXor
- [ ] $bottom
- [ ] $bottom (accumulator)
- [ ] $bottomN
- [ ] $bottomN (accumulator)
- [ ] $bsonSize
- [x] $ceil
- [ ] $cmp
- [x] $concat
- [ ] $concatArrays
- [x] $cond
- [ ] $convert
- [x] $cos
- [x] $cosh
- [ ] $count (accumulator)
- [ ] $covariancePop
- [ ] $covarianceSamp
- [ ] $dateAdd
- [ ] $dateDiff
- [ ] $dateFromParts
- [ ] $dateFromString
- [ ] $dateSubtract
- [ ] $dateToParts
- [ ] $dateToString
- [ ] $dateTrunc
- [ ] $dayOfMonth
- [ ] $dayOfWeek
- [ ] $dayOfYear
- [x] $degreesToRadians
- [ ] $denseRank
- [ ] $derivative
- [x] $divide
- [ ] $documentNumber
- [x] $eq
- [ ] $exp
- [ ] $expMovingAvg
- [x] $filter
- [ ] $first
- [ ] $first (accumulator)
- [ ] $firstN (accumulator)
- [x] $firstN (array)
- [x] $floor
- [ ] $function
- [x] $getField
- [x] $gt
- [x] $gte
- [ ] $hour
- [ ] $ifNull
- [ ] $in
- [ ] $indexOfArray
- [ ] $indexOfbytes
- [ ] $indexOfCP
- [ ] $integral
- [x] $isArray
- [x] $isNumber
- [ ] $isoDayOfWeek
- [ ] $isoWeek
- [ ] $isoWeekYear
- [ ] $last
- [ ] $last (accumulator)
- [ ] $lastN (accumulator)
- [x] $lastN (array)
- [ ] $let
- [ ] $linearFill
- [x] $literal
- [ ] $in
- [ ] $locf
- [ ] $log
- [ ] $log10
- [x] $lt
- [x] $lte
- [x] $ltrim
- [x] $map
- [ ] $max
- [ ] $max (accumulator)
- [ ] $maxN (accumulator)
- [ ] $maxN (array)
- [ ] $median
- [x] $median (accumulator)
- [ ] $mergeObjects
- [ ] $meta
- [ ] $min
- [ ] $min (accumulator)
- [ ] $minN (accumulator)
- [ ] $minN (array)
- [ ] $millisecond
- [ ] $minute
- [ ] $mod
- [ ] $month
- [x] $multiply
- [x] $ne
- [ ] $not
- [ ] $objectToArray
- [ ] $or
- [x] $percentile (accumulator)
- [ ] $pow
- [ ] $push
- [ ] $push (accumulator)
- [x] $radiansToDegrees
- [ ] $rand
- [ ] $range
- [ ] $rank
- [ ] $reduce
- [ ] $regexFind
- [ ] $regexFindAll
- [ ] $regexMatch
- [x] $replaceOne
- [x] $replaceAll
- [ ] $reverseArray
- [ ] $round
- [x] $trim
- [ ] $sampleRate
- [ ] $second
- [ ] $setDifference
- [ ] $setEquals
- [ ] $setField
- [ ] $setIntersection
- [ ] $setIsSubset
- [ ] $setUnion
- [ ] $shift
- [ ] $size
- [x] $sin
- [x] $sinh
- [ ] $slice
- [x] $sortArray
- [x] $split
- [ ] $sqrt
- [ ] $stdDevPop (accumulator)
- [ ] $stdDevSamp (accumulator)
- [x] $strLenBytes
- [x] $strLenCP
- [x] $substr
- [x] $substrBytes
- [x] $substrCP
- [x] $subtract
- [ ] $sum
- [x] $sum (accumulator)
- [x] $switch
- [x] $tan
- [x] $tanh
- [x] $toBool
- [x] $toDate
- [ ] $toDecimal
- [x] $toDouble
- [ ] $toHashedIndexKey
- [x] $toInt
- [x] $toLong
- [x] $toObjectId
- [ ] $top
- [ ] $top (accumulator)
- [ ] $topN
- [ ] $topN (accumulator)
- [x] $toString
- [x] $toLower
- [x] $toUpper
- [x] $toUUID
- [ ] $tsIncrement
- [ ] $tsSecond
- [x] $trim
- [ ] $trunc
- [x] $type
- [ ] $unsetField
- [ ] $week
- [ ] $year
- [ ] $zip
Variables:
- [ ] NOW
- [ ] CLUSTER_TIME
- [ ] ROOT
- [ ] CURRENT
- [ ] REMOVE
- [ ] DESCEND
- [ ] PRUNE
- [ ] KEEP
- [ ] SEARCH_META
- [ ] USER_ROLES
https://www.mongodb.com/docs/manual/reference/aggregation-variables/
issue