Tips & Tricks - Filtering for Boolean values

General

The workshop focuses on filtering tables by Boolean values. In the example application, tasks can be entered and then marked as completed or not completed.

The table on the start page can be filtered accordingly using a selection list. You can download the sample application here and then import it as usual.

Application structure

Here you can see the input page of the sample application, on which there is an input field for the title of the task and a checkbox for marking the task as completed or not completed.

On the "All entries" page, the data records displayed in the view table can be filtered using a selection list. In the properties dialog of the selection list, the setting "First entry in the list is empty" is set to create the empty entry that can be used to deactivate the filter.

On the "Entries" tab, the "Boolean (logical value)" type is selected as the data type of the saved value. The values in the drop-down list, i.e. the options for the filter, are defined here as user-defined values.

A corresponding dependency is defined in the properties of the table that is to be filtered.

The filter drop-down list is defined as the control. The filter is triggered by the onchange event. It compares the value entered for each task in the Completed data field with the value in the selection list using the "Equal" operation.