1. Administering Data Management for Oracle Enterprise Performance Management Cloud
  2. Integration Tasks
  3. Loading Data
  4. Using the Data Load Workbench
  5. Using the Workbench Data Grid
  6. Querying by Example

Querying by Example

Use the Query by Example feature to filter rows that are displayed for a specific column. You can enter text to filter on, if available, for a specific column, and then click Enter. To clear a filter, remove the text to filter by in the text box, then click Enter. All text you enter is case sensitive.

To query by example:

  1. From the table action bar, click Image shows Query by Example icon to enable the filter row.

    The filter row must appear above the columns to use this feature.

  2. Enter the text by which to filter the values in the column and click Enter.

    Note:

    When entering text to filter, the text or partial text you enter is case-sensitive. The case must match exactly. For example, to find all target applications prefixed with "HR", you cannot enter "Hr" or "hr".