Filter on a Range

Related Topics

To define a range of filter values other than Date or Date/Time in the summary table:

  1. Click from the page toolbar to display the Environment page, and then click the Filter Settings tab.

  2. Click in the Qualifier column that corresponds to the field on which you want to filter, and then select Between from the list of available options.

Qualifiers are Boolean operators used in conjunction with both the Filter and Value(s) columns.

  1. Click in the Value(s) column to display the Enter Filter Values for <Filter> Range page for you to define specific values for the range.

<Filter> in the page title is replaced with the name of the current filter. For example, to filter on a range of Check #s, select the corresponding Between qualifier. <Filter> is replaced with Check # and the Enter Filter Values for Check # Range page displays when you click .

  1. Type the lowest or starting number or letter in the From box

  2. Type the highest or ending number or letter in the To box.

  1. Click OK to display the entered range values in the Value(s) cell on the Filter Settings tab. The range displays as From value - To value.

  2. Click OK on the Environment page to display the summary table with the filtered data for this session only. You can also save and cancel filter settings from this page.

     

    Click:

    To:

     

    Save the filter(s). Refer to Save Environment Settings for details on saving filters.

     

    Cancel any changes made to the Environment page.

     

    Revert to your previously saved filter settings.

For information on filtering on Date and Date/Time ranges, refer to Filter on a Date Range and Filter on a Date/Time Range.