Thank you for your feedback.
Form temporarily unavailable. Please try again or contact to submit your comments.

Create a normalized query for field transformations

Log in to subscribe to topics and get notified when content changes.

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.


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