Page History

Boolean

Filtering a boolean value can be done by selecting whether to show rows of the list with value true and/or value false and/or value unknown.
It is possible to select any combination of the three options.

Value list

Filtering a column which is bound by a value list resembles the functionality that is available in many table-oriented applications, such as Microsoft Excel.
All distinct values of the value list are available in a list and the user can select and deselect items at will.

Unknown values can be included and excluded from the filter by using the "Show Unknown" checkbox, which is by default selected. This means that by default, all rows of the list where the value is unknown, are also shown.
The checkbox "Select All" can be used to quickly show the complete known content of the column again, so it will clear the provided filter for this column.

String

To filter a string column of a list, you simply type (part of) the string that you are looking for.

By default, unknown values are also shown. To disable this, deselect the checkbox labeled "Show Unknown".
The checkbox "Show All" can be used to quickly show the complete known content of the column again, so it will clear the provided filter string for this column.

Number

Filtering a number (integer, numeric, percentage or currency) provides three options.
It is possible to filter only values that are equal (=) to a certain value, greater than or equal to a certain value (>=) or smaller than or equal to a certain value (<=).
It is possible to combine the greater than or equal to option (>=) with the smaller than or equal to option (=<) to establish a range.
Combining (>=) or (<=) with (=) is not possible, since (>=) and (<=) already contain the boundary-numbers.

By default, the "Show Unknown" checkbox is selected. This means that by default, all rows of the list where the value is unknown, are shown.
The checkbox "Show All" can be used to quickly show the complete known content of the column again, so it will clear the provided filter values for this column.

Date(time)

Date an datetime filtering strongly resembles number filtering.

Filtering a date also provides three options.
It is possible to specify to filter dates that are equal to a certain date (On), from a certain date (From) and to a certain date (To).
Combining the From and To option is possible to establish a period in time.
Combining From or to with On is not possible, since From and To already contain the boundary-date.

By default, the "Show Unknown" checkbox is selected. This means that by default, all rows of the list where the value is unknown, are shown.
The checkbox "Show All" can be used to quickly show the complete known content of the column again, so it will clear the provided filter values for this column.

Datetime filtering works the same as date filtering, with the addition of a timestamp HH:mm.