Thank you for your feedback.
Form temporarily unavailable. Please try again or contact to submit your comments.
  • London
  • Kingston
  • Jakarta
  • Istanbul
  • Helsinki
  • Geneva
  • Store

Create a normalized query for field transformations

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