On the Filters tab, you specify the fields, operators, and values
that determine the results that are shown in a report. The selected filters run sequentially.
Reports run faster if the filter that filters out the most records is specified first, followed by
the one that filters out the next highest number of records
Procedure
-
Select a business object.
-
In the Columns section, for each field that is used as a filter, select the check box in the
User or System column.
-
In the User Filter Columns section and System Filter Columns section, select a field and change
the sequence in which the filters are applied.
-
To change the label that is shown for a filter, edit the text in the Report
Label text box. If the field is a time field, input the time in milliseconds or as a
string in hh:mm:ss format.
-
From the Filter Operator drop-down box, select the comparison filter
operator.
-
From the Conditional drop-down box, select the conditional option. If
you select Yes, the system filter is ignored in the query results when the
filter input is empty.
-
For system filters with a value for run time, specify the value that must be matched. To filter
a Boolean field, use the values TRUE or
FALSE.
-
Select the Join Operator to organize system filters in sets to further
refine the order that the filters are applied.
-
Select Save.
Tip: To add all display columns to the User Filter Columns section, click
Copy All Display Columns.