Filtering Table Records

If you want ALX tables to show only certain records of the database table, you should filter the data in the corresponding column(s) of the table. 

You can filter data by:

The filtering equation should be typed into the filter cell beneath the column title.

To filter table records by text

  1. Click the filter cell beneath the column title and type in the text that will be used to filter the column data. In our case we filter the data in the Country column by Netherlands.

    The column data will be filtered according to the specified text.

  2. To remove the filter, simply click the icon to the right of the Netherlands.

You can perform data filtering either by the explicitly specified numeric value or by specifying if the filtering data should be more than the specified value (>0), less than the specified value (<0), should equal the specified value (=0), should not equal the specified value (<>0), should be more than the specified value or equal to it (>=0) or should be less than the specified value or equal to it (<=0).

We will use the Products table for the following scenarios.

 To filter table records by the explicitly specified numeric value

  1. Click the grey cell beneath the Selling Price, $ column title and type in specific numeric value (31) that will be used to filter the column data.

    The column data will be filtered according to the specified numeric value.

  2. To remove the filter, simply click the icon to the right of the specified numeric value 0,2.

To filter table records by the more, less, etc. conditions

  1. Click the filter cell beneath the Selling Price, $ column title and type in the desired condition. We will type in less than condition (<100).

    The column data will be filtered according to the specified condition.


    In the same way you may filter the data column according to all other conditions.

  2. To remove the filter, simply click the icon to the right of the specified condition (<100).

The data can be also filtered by date.

To filter table records by date

  1. Click the filter cell beneath the column title and type in the desired date.
  2. To remove the filter, simply click the icon to the right of the specified.

Table columns may contain toggle buttons as a type of data that a user and ALX use for scenarios. The toggle buttons define whether the certain data will be included or excluded from the scenario (or switching between certain states e.g. straight routes/actual routes).

To filter table records with the help of toggle button

  1. Click the grey cell beneath the column title and type in true if you want to filter the checked data and false to filter the data which is not checked.

  2. To remove the filter, simply click the icon to the right of the specified condition.