Inserting a profile category into a query

While building a query expression in a process configuration dialog, you can insert a field value into your query expression.

While configuring a process, select a field and click the Profile button.

When profiling is finished, from the Profile Selected Field dialog, double-click a category to insert that value at the current cursor location in the query text box.

If you do not see the value that you want, it is possible that multiple values are being grouped together into a profile segment. If you set the maximum number of profile segments to a number greater than the number of categories (reported in the Profile Selected Field window), each field value will be listed as a separate category. This makes it possible to access all of the existing categories.