anyLogistix anyLogistix
Expand
Font size

Filtering Table Records

If you want anyLogistix tables o 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 filter field accepts:

  • greater than the specified value (>0)
  • less than the specified value (<0)
  • equal to the specified value (=0),
  • should not be equal to the specified value(<>0)
  • greater than the specified value or equal to it (>=0)
  • less than the specified value or equal to it (<=0)
  • true or false statements

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.

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 anyLogistix 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.

How can we improve this article?