Filters

The User filter and Dashboard filter operands are introduced in the Expression editor for on-demand records and metrics.

Use User filter to add any existing user filter to the expression. The value of this operand is used for a logged in user when data is requested for the record. See the Kofax Insight Help for Admin Console for more information about creating User filters.

Add the Dashboard filter operand to the expression to use a dashboard filter when data is requested for the record. You should define a dimension as a parameter. You can define any source field, string literal, or an existing constant document as a dimension.

Insight replaces the User filter and Dashboard filter expressions with string values from the filter using the Unicode format. If you strongly require to use a non-Unicode format, use custom query. If the filter contains multiple values, they are separated by commas, for example: N'A', N'B'.

If the filter option does not contain any values, the template is replaced with NULL.

You can use the Is filter empty operand to check if the required filter contains any values. If the filter is empty, the function is replaced with "1=1", otherwise, it is replaced with "1<>1". You should define the User filter or Dashboard filter operands as a parameter for Is filter empty.