Filter operators

In advanced filter modes you can apply operators.

Available Filter Operators:
  • Equal To
  • Greater Than
  • Less Than
  • Greater Than or Equal To
  • Less Than or Equal To
  • Not Equal To
  • is missing
  • (is not missing)
  • Outside
These operators are displayed at the bottom of the operator list when the data type is incompatible:
  • Contains
  • Does Not Contain
  • Between
Note: When the Contains or Does Not Contain operator is selected, a percent sign (%) can be used as a wildcard.
Examples:
  • %Company% returns values that contain ''Company.''
  • Company% returns values that begin with ''Company.''

Locking a Filter Operator:

By default, the operator in a filter can be changed. To require use of a specific operator, click the Lock icon.

Examples:
  • Lock a date picker so that users specify one date instead of a date range.
  • Lock a filter on a Varchar column to use Equal to, because the Greater than and Less than operators sort alphabetically and may return unexpected results.