The columns in the Table widget can be filtered. You can search for a specific value in a short checkbox list or use the advanced text input. 

As described below, the multi selection option is provided with the Select from List button. The Advanced Filter button switches to a text search with the following conditions:

  • Starts with
  • Contains
  • Ends with
  • Is equal to
  • Is not equal to
  • Is empty
  • Is not empty

The column filter is only applied to data that is already in the table. It does not reload the data.

Prerequisites

In the configuration page, you have activated the Show column filter checkbox and set in the List display threshold field the maximum number of items to show in the filter list:

For entries above the threshold, only the advanced search is available.
The value of the list display threshold must not be greater than 1000.

Proceed as follows

  1. Click the filter icon in the column you want to filter.
  2. In case of the
    1. Select from List option:
      Select all or the individual options you want to filter for:
    2. Advances Filter option:
      1. In the Condition drop-down list, select a condition.
      2. In the Value field, enter the value with which you want to filter the column.
  3. Click the Filter button.
    → The table is filtered accordingly.

To remove the filters, click the Clear column filters button above the table.

Limiting the number of table entries

Proceed as follows

  1. Click the Settings drop-down list.

  2. Select the number of table entries to be displayed.
    → The number of displayed entries is adjusted accordingly.

    The selected number of displayed entries is saved locally.