Setting Filter Values for Relational Databases

The Set Values area displays the values for the filters.

  To access properties:

  1. From Explore, select an item.

  2. Right-click a job and selectRun Job.

    Properties is displayed.

    Option

    Description

    Query Name

    (Read-only) Query name

    Filter Name

    (Read-only) Name of the field that the filter is on from the Interactive Reporting job

    Operator

    (Read-only) The operator that the filter uses, such as =, <, or >

    Values

    (Read-only) The values that the filter uses (Variable system values such as $USER, are acceptable. The values are from the database that the query is using.)

    Ignore

    Disables the filter when the query is processed

    Don’t Prompt

    Disables prompting for runtime values. (A dynamic value, such as a system variable can be used for a value(s). This option essentially changes the variable filter to a static filter with fixed values.)

    Modify Filter

    Enables modification of a selected filter.

    Include nulls

    Enables inclusion of an “is null” condition in the SQL sent to the database when the query is processed.

    Operator

    (Read-only) The operator that the filter uses, such as =, <, and >

    Show values

    Retrieves from the database all available values associated with the item you can consider and select from the range of values when applying a filter.

    Custom values

    Lists available values saved with the filter or read from a file, you can select values from a pre-defined pool. You can create and save a custom list with each filter.