Supported query operators
The following query operators are supported:
$and$or$not$eq- Equals$exists$gt- Greater Than$gte- Greater Than or Equals$lt- Less Than$lte- Less Than or Equals$in$ne- Not Equals$regex$options- regex options$text- text search on the content of the fields indexed with a text index$sum$avg$max$min$type
Supported Aggregation Pipeline Stages#
Currently Itemservice supports aggregation api on readings. The below Aggregation Pipeline Stages are supported.
Supported Aggregation Pipeline Operators#
- $abs
- $add
- $addToSet
- $and
- $avg
- $ceil
- $cmp
- $concat
- $cond
- $count
- $dateAdd
- $dateDiff
- $dateFromParts,
- $dateFromString
- $dateSubtract
- $dateToParts
- $dateToString
- $dateTrunc
- $dayOfMonth
- $dayOfWeek
- $dayOfYear
- $denseRank
- $derivative
- $divide
- $documentNumber
- $eq
- $expMovingAvg
- $first
- $floor
- $gt
- $gte
- $in
- $isArray,
- $isNumber
- $last
- $lt
- $lte
- $ltrim
- $max
- $min
- $minute
- $month
- $mod
- $multiply
- $ne
- $not
- $or
- $pow
- $push
- $rank
- $regexFind
- $regexFindAll
- $regexMatch
- $round
- $rtrim
- $second
- $shift
- $size
- $sqrt
- $stdDevPop
- $strcasecmp
- $substr
- $subtract
- $sum
- $toString
- $toLower
- $toUpper
- $trim
- $trunc
- $type
- $week
- $year
- $exists