Operators

Equals: = or ==

The "Equals" operator is used to search records where the value of the specified selector exactly matches the specified value.

Example:

age = 18

age == 18

Not Equals: != or <>

The "Not Equals" operator is used to search records where the value of the specified selector is different of the specified value.

Example:

age != 18

age <> 18

Greater: >

The "Greater" operator is used to search records where the value of the specified selector is greater than the specified value.

Example:

age > 18

Greater Equals: >=

The "Greater Equals" operator is used to search records where the value of the specified selector is greater or equals than the specified value.

Example:

age >= 18

Less: <

The "Less" operator is used to search records where the value of the specified selector is less than the specified value.

Example:

age < 18

Less Equals: <=

The "Less Equals" operator is used to search records where the value of the specified selector is less or equals than the specified value.

Example:

age <= 18

In:

The "In" operator is used to search for records where the value of the specified selector is one of multiple specified values. The values are specified as a comma-delimited list, surrounded by parentheses.

Example:

age in (15, 21, 40) 

Not In: not in or !in

The "Not In" operator is used to search for records where the value of the specified selector is not one of multiple specified values. The values are specified as a comma-delimited list, surrounded by parentheses.

Example:

age not in (15, 21, 40) 

age !in (15, 21, 40) 

Like:

The "Like" operator is used to search for records where the value of the specified selector matches the specified value.

Example:

name like "John Doe"

You can use the wildcard "%" to create a "starts with" condition

name like "John%"

Not Like: not like or !like

The "Not Like" operator is used to search for records where the value of the specified selector not matches the specified value.

Example:

name not like "John Doe"

name !like "John Doe"

Is Empty:

The "Is Empty" operator is used to search for records where the value of the specified selector is an empty string.

Example:

name is empty

Is Not Empty: is empty or !empty

The "Is Not Empty" operator is used to search for records where the value of the specified selector is an empty string.

Example:

name is not empty

name !empty

Is True:

The "Is True" operator is used to search for records where the value of the specified selector is a boolean true value.

Example:

validated is true

Is False:

The "Is False" operator is used to search for records where the value of the specified selector is a boolean false value.

Example:

validated is false

Is Null:

The "Is Null" operator is used to search for records where the value of the specified selector is null.

Example:

name is null

Is Not Null: is not null or !null

The "Is Not Null" operator is used to search for records where the value of the specified selector is not null.

Example:

name is not null

name !null