Tips & Tricks - Filtering with Boolean values
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 homepage can be filtered accordingly via the drop-down list. The example application can be downloaded here and imported into your portal as usual.
On the "All entries" page, the data records, which are displayed in the view table, can be filtered with a drop-down list. In the properties dialog of the drop-down list, the "First entry on list is blank" setting is active, to create a blank entry that deactivates the filter.
On the Entries tab, "Boolean (Logical value)" 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.
The filter drop-down list is defined as the control. The filter is triggered by the onchange event. It compares the value of the "Completed" field for each task with the value of the drop-down list using the "Equals" operator.
The application in the browser
You can see how the filter affects the task list in the table in the browser here.