Q
Comparison Operators
| Operator | Description | q |
|---|---|---|
| $eq | Match values that are equal to a specified value | {is_inventory: { $eq: true}} This is equivalent to {is_inventory: true} |
| $gt | Match values that are greater than a specified value | {regulatory_burden: { $gt: 0.685085117816925}} |
| $gte | Match values that are greater than or equal to a specified value | {regulatory_burden: { $gte: 0.685085117816925}} |
| $lt | Match values that are less than a specified value | {regulatory_burden: { $lt: 0.685085117816925}} |
| $lte | Match values that are less than or equal to a specified value | {regulatory_burden: { $lte: 0.685085117816925}} |
| $ne | Match all values that are not equal to a specified value | {regulatory_burden: { $ne: 0.685085117816925}} |
| $in | Match any of the values specified in an array | {substance_id: {$in: [1,40,2503]}} |
| $nin | Match none of the values specified in an array | {substance_id: {$nin: [1,40,2503]}} |