Filter operators for tables

Use filter (query) operators to find rows in a table. You can use filter operators on all supported types except map, list, set, and vector.

For examples, see the references for commands that use these operators, such as Find a row, Find rows, and Find distinct values.

Operator type Name Purpose

Operator type	Name	Purpose
Comparison query (Range)	`$gt`	Matches rows where the given column’s value is greater than the specified value.
	`$gte`	Matches rows where the given column’s value is greater than or equal to the specified value.
	`$lt`	Matches rows where the given column’s value is less than the specified value.
	`$lte`	Matches rows where the given column’s value is less than or equal to the specified value.
Comparison query (Exact)	`$eq`	Matches rows where a given column’s value equals the specified value. This is the default when you do not specify an operator. This is the only filter operator allowed in `updateOne` and `deleteOne`.
	`$ne`	Matches rows where a given column’s value does not equal the specified value.
	`$in`	Match one or more of an array of specified values. For example, `"filter": { "COLUMN_NAME": { "$in": [ "VALUE", "VALUE" ] } }`. If you have only one value to match, an array is not necessary, such as `{ "$in": "VALUE" }`.
	`$nin`	Matches any of the values that are NOT IN a given array.

Comparison query (Range)

$gt

Matches rows where the given column’s value is greater than the specified value.

$gte

Matches rows where the given column’s value is greater than or equal to the specified value.

$lt

Matches rows where the given column’s value is less than the specified value.

$lte

Matches rows where the given column’s value is less than or equal to the specified value.

Comparison query (Exact)

$eq

Matches rows where a given column’s value equals the specified value. This is the default when you do not specify an operator.

This is the only filter operator allowed in updateOne and deleteOne.

$ne

Matches rows where a given column’s value does not equal the specified value.

$in

Match one or more of an array of specified values. For example, "filter": { "COLUMN_NAME": { "$in": [ "VALUE", "VALUE" ] } }.

If you have only one value to match, an array is not necessary, such as { "$in": "VALUE" }.

$nin

Matches any of the values that are NOT IN a given array.

Examples

The $eq (equals) operator finds exact matches. The following example retrieves rows where the customer column has the name "Jasmine S." and the city "Jersey City":

"find": {
  "filter": {
    "customer": {
      "$eq": {
        "name": "Jasmine S.",
        "city": "Jersey City"
      }
    }
  }
}

$eq is the default operator if you do not specify an operator:

"find": {
  "filter": {
    "customer": { "name": "Jasmine S.", "city": "Jersey City" }
  }
}

Use $ne to match rows that do not have the given filter value:

"find": {
  "filter": {
    "$ne": {
      "state": "NJ"
    }
  }
}

Use $in to match any of a series of specified values:

"find": {
  "filter": {
    "city": {
      "$in": [ "Jersey City", "Orange" ]
    }
  }
}

Similarly, use $nin to match rows that don’t have any of the specified values.

Filter operators for tables

Examples

Was this helpful?

Give Feedback