Define Filter dialog for Row Filter Operator

Defines the filter conditions.

You can specify row filters in two modes:

  • Simple mode: Use a simple template to define the filter, choosing a column, an inequality (for example, ">" or "between"), and a value (for example, a literal value or a column expression).
  • Script mode: Specify any set of filters by using a script.
Note: If you switch from Simple mode to Script mode, your filters are converted to script. However, your script is lost if you switch from Script mode to Simple mode.

Simple Mode

For Simple Mode, you can add multiple condition filters by clicking the add new filter link.

To define a filter, select a column, a condition, and a value or expression.

AND/OR: You must also specify whether all filters must be met for each row (AND conditions), or just one of the filters (OR conditions).

Simple Mode Conditions
Condition
=
<>
>
<
>=
<=
contains
between
is null
is not null
is blank
  • If your filter value is not numeric, you must add single quotes; for example, status = 'Active'.
  • If your filter value is numeric or an expression, you do not need to use quotes (for example, start_date = current_date, or customer_id > 37).
  • If your filter value is a column and the column name contains spaces or uppercase characters, you must add double quotes (for example, "Start Date" - 1)
Script Mode

In Script mode, filters are added as a "where" clause.

  • You do not need to add the WHERE keyword.
  • You can combine multiple filters with boolean expressions (AND, OR, and so on) and parentheses.
  • Any expression that fits within a WHERE clause can be used.