Database filter operators

Function	Explanation
EQUAL	Applies if the values are equal.
NOT_EQUAL	Applies if the values are not equal.
GREATER	Applies if the value from the database is greater than the filter value.
SMALLER	Applies if the value from the database is less than the filter value.
GREATER_OR_EQUAL	Applies if the value from the database is greater than or equal to the filter value.
SMALLER_OR_EQUAL	Applies if the value from the database is less than or equal to the filter value.
IN	Applies if the value in the database is included in the list from the filter value.
NOT_IN	Applies if the filter value is not present in the value from the database.
LIKE	Applies if the value from the database matches the pattern from the filter value.
LIKE_WILDCARD	Applies if the value from the database contains the filter value or the pattern from the filter value.
LIKE_WILDCARD_END	Applies if the value from the database begins with the filter value or pattern from the filter value.
NOT_LIKE_WILDCARD	Applies if the value from the database does not contain the filter value or pattern from the filter value.

note

In the Like or Wildcard filters, "%" and "_" can be used as placeholders.

"%" stands for any number of any characters, including spaces.

"_" stands for a single arbitrary character.