Skip to main content

Use expressions and parameters

Filter expressions

Define the values a filter should include or exclude—without changing its columns or adding rows.

An expression item evaluates a selected column against a logical operator and value. It can only return the same columns and the same or fewer rows than its input; it is not a join. To combine related tables, use Relation items.

Build an expression itemDirect link to Build an expression item

Build a filter expression

Select a column and operatorDirect link to Select a column and operator

When you create or edit a filter, add an Expression filter item. Select the column to evaluate, then choose the operator that best represents the condition.

Step 1 of 3

Choose an operatorDirect link to Choose an operator

Date fields accept values that are already dates or timestamps, including values supplied by lookup tables. Check the source type and preview the comparison before adding a conversion solely to satisfy a date field.

OperatorWhat it checks
Contains (ci) / Not Contains (ci)A case-insensitive whole-string or substring match, or its inverse.
Equals (ci) / Not Equals (ci)A case-insensitive whole-string match, or its inverse.
Equals / Not EqualsA case-sensitive whole-string match, or its inverse.
Exists / Not ExistsWhether the selected column has a non-empty value, or does not.
In / Not InWhether the value is, or is not, in a comma-separated list.
RegexA regular-expression pattern; flags are supported, for example /[ab]/i.
Matches / Not MatchesA regular-expression-like pattern without flags, or its inverse, for example [ab].
Starts-With (ci) / Not Starts-With (ci)A case-insensitive match at the beginning of the value, or its inverse.
Starts-With (cs) / Not Starts-With (cs)A case-sensitive match at the beginning of the value, or its inverse.
tip

Expression items cannot evaluate a column from another table directly. Use a lookup when you need to test whether a value exists in a different system table.

ParametersDirect link to Parameters

Parameters replace a fixed expression value. They do not add new filter behavior; they make the filter reusable when a caller supplies a different value.

Common uses include:

  • Reusing a filter in multiple roles with similar inclusion criteria.
  • Supplying the member-filter value in a role generator.
  • Reusing a lookup filter in an app or process with a runtime value.

An input parameter has a data type and default value. A variable parameter takes its value from a NIM variable. The default is only used while previewing the filter during configuration; a caller overrides it when it uses the parameterized filter.

Add a parameter to an expressionDirect link to Add a parameter to an expression

  1. Edit the filter containing the expression item.
  2. On the item, select Constant/Parameter. The fixed-value field becomes Value Of Parameter.

  1. Open Parameters and select Add Parameter. Name it, then choose input for a caller-supplied value or variable for a value from a NIM variable. An input parameter also needs a data type and preview default.
  2. Return to the expression and choose the new parameter from Value Of Parameter.
  3. Preview records with representative values and select Save.

To use a fixed value again, select Parameter/Constant, enter the constant, and save the filter.