Criteria and visual indicators
The values or criteria entered for the filter define the items that will be displayed on the screen, the "No filter" type will display all records, other criteria are explained below
Is NULL
|
Will display all records for which there is no item in this field.
|
Not NULL
|
Will display all records for which there is an element entered in this field.
|
Greater [>]
|
Will display all records for which the value in this field is greater than the value entered in the criterion field.
|
Greater or equal to [>=]
|
Will display all records for which the value in this field is greater than or equal to the value entered in the criterion field.
|
Smaller [<]
|
Will display all records for which the value in this field is smaller than the value entered in the criterion field.
|
Smaller or equal to [< =]
|
Will display all records for which the value in this field is less than or equal to the value entered in the criterion field.
|
Equal [=]
|
Will display all records for which the value in this field is equal to the value entered in the criterion field
|
Different from
|
Will display all records for which the value in this field is different from the one entered in the criterion field.
|
|
Included between
|
Will display all records whose value in this field is included between the value entered in the first criterion field and the value entered in the second criterion field.
In the example below, the displayed records will be between May 1, 2019 and May 31, 2019.
|
Excluded between
|
Will display all records whose value in this field is not included between the value entered in the first criterion field and the value entered in the second criterion field.
In the example below, the records displayed will be those with a date before January 1, 2018 and after December 31, 2018, that is excluding the 2018 records.
|
List of values
|
This type of filter should only be used in columns or numeric fields. Enter the values on a single line separated by a comma or use the "Enter" key on your keyboard.
In the example below, the records displayed will be invoices with numbers 24, 2112 and 2130.
|
|
Exclude checked items
|
When this type is selected, a list of all existing values for this field appears in the "Configuration" field. Check the items to be hidden. All records with a value different from all checked values will be displayed.
|
Include checked items
|
When this type is selected, a list of all existing values for this field appears in the "Configuration" field. Check the items to be displayed. All records with a value equal to one of the checked values will be displayed.
|
Checked only
|
Applicable for any checkbox column. When this type of filter is selected, only the records with the checkbox checked will be displayed.
|
Unchecked only
|
Applicable for any checkbox column. When this type of filter is selected, only records with the checkbox unchecked will be displayed.
|
|
Filter - single criterion