Searching for Data Using Flexfield Criteria

Searching for Data Using Flexfield Criteria

You can enter search criteria in a flexfield when you use query-by-example. By entering search criteria in a flexfield, you can retrieve records of data that satisfy criteria in the individual segments of your key or descriptive flexfields. For example, suppose you want to search for all Accounting Flexfield combinations in the Accounting Flexfields Combinations window that contain the segment value "01" in the first segment. With query-by-example, you can enter this criteria in the Accounting Flexfield to accomplish this task.

When you enter search criteria for a flexfield segment, you can use wildcard characters or any of the query operators as part of the search phrase.

If your flexfield segment has a list available, you can choose the List icon within the flexfield window to select a value from the list for your search criteria. Note that if you enter a value for a segment, your application automatically enters the default value for any other segments that depend on the value you enter. If you do not want a default value as part of your search criteria, you can clear the field, or you can enter another value in that field.