Create a normalized query for field transformations

An administrator can configure transformations to apply to queries issued against transformed fields in lists.

About this task

For more information on configuration, see Create a transformation record.

Procedure

In the list, create a filter using the original (raw) value for the transformed field in the query condition.
Transformation filter
Note: Normalized queries for field transformations only work for [is] or [is not] queries.

The filtered list returns records with the transformed value substituted for the raw value. However, the breadcrumbs for the filter display the original query conditions (raw value).

Filtered list