Condition values act as operators such as equals, not equals, is more than, is less than, contains, does not contain, and so on. Both the Condition and data Value lists are constrained by the Column data type.
in
Select documents that match one or more values specified in the Value field.
not in
Select documents that do not match one or more values specified in the Value field.
is empty
Select documents with one or more property attributes that are empty.
is not empty
Select documents with one or more property attributes that are not empty.
on
Select documents that have a matching date.
on or before
Select documents that have a date that is on or before the date specified in the Value field.
on or later
Select documents that have a date that is on or after the date specified in the Value field.
equals
Select documents that have an exact matching value specified in the Value field.
not equals
Select documents that do not exactly match a value specified in the Value field.
is more than
Select documents that have a value greater than the numeric value specified in the Value field.
is less than
Select documents that have a value less than the numeric value specified in the Value field.
is at least
Select documents that have a value equal to or greater than the numeric value specified in the Value field.
is at most
Select documents that have a value equal to or less than the numeric value specified in the Value field.
contains
Select documents that contain the text specified in the Value field.
is
Select documents that exactly match the text specified in the Value field.
does not contain
Select documents that do not contain the text specified in the Value field.
contains any
Select documents that contain any of the values specified in the Value field.
contains all
Select documents that contain all of the values specified in the Value field.
does not contain any
Select documents that do not contain any of the values specified in the Value field.
does not contain all
Select documents that do not contain all of the values specified in the Value field.
Multi-user Considerations