Filter operators

Advanced filter modes can apply operators such as equal to, not equal to, greater than or equal to, less than or equal to, contains, does not contain, is missing, is not missing, between, or outside.

If an operator is not relevant to the data type of the filter, it shows at the bottom of the dropdown.

Note: When using the Contains or Does Not Contain operators, business users can add the percent character (%) to search strings. The percent character acts as a wildcard around keyword strings. For example, "%Company%" returns all values that have "Company" in the string. "Company%" returns all values that begin with "Company".

Locking a Filter Operator:

By default end users can change the operator of a filter. If you do not want to provide this feature to end users, you can restrict the filter to use only the operator that you set up. You can click the Lock icon to lock a filter operator.

For example, you can lock a date picker so that end users cannot select a range, they can only select one date.

For another example, it may not make sense to allow the greater than or less than operators (> or <) on Varchar columns, as they will sort alphabetically. For many Varchar columns, we recommend an equality (=) operation.