Filter type properties

NO FILTER
Selecting the filter type NO FILTER does not display additional fields.
FILTER BY RANGE

Displays the following:

From Value
Start value to be searched for.
To Value
End value to be searched for.
Range Mode
Values in range are included
Considers values within the specified range.
Values in range are excluded
Considers values outside the specified range.
FILTER BY USER EXIT

Displays the following:

User Exit name
Name of the user program performing the selection.
FILTER BY LIST VALUE

Displays the following:

Values List
One or more values to be selected.
List Mode
Values in list are included
Considers values in the list.
Values in list are excluded
Considers values outside the list.
FILTER BY FILTERED LIST

Selecting the filter type FILTER BY FILTERED LIST does not display additional fields.

FILTER BY EXISTING FILTER
Selecting the FILTER BY EXISTING FILTER filter displays a grid where you can perform drag-and-drop operations to group filters by columns.
FILTER BY NULL

Enables the extraction to select all records having null values for the selected columns. Valid for distributed data stores only.

FREE QUERY
Enables insertion of a specific statement to execute in correspondence of the specified elaboration.
Parent topic: Filter types