Easy Filter

Applies filters on the current dataset using a filter row under the table header.

The result is stored in a variable:

• 0: No records found
• 1: A record found (conditions are met).

See Records and occurrences.

Fields in the editor

Column

The column to filter.

Operator

The operator to be used:

• = (eq)
• <> (ne)
• > (gt)
• >= (ge)
• < (lt)
• <= (le)
• starts with (startsWith)
• does not start with (doesNotStartWith)
• contains (contains)
• does not contain (doesNotContain)
• ends with (endsWith)
• does not end with (doesNotEndWith)
• empty (empty)
• not empty (notEmpty)
• in range

Variable/Value

The filter value or the variable that stores the filter value.

Store result in

The variable to store the filter result.

Clear filter

Select this check box to clear the previous filter expression before applying the new one.