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

You can filter data by:

• Text
• Numeric value
• Condition
• Date
• Toggle buttons

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

Type the filtering equation into the filter cell below 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 Name column by Medic to see all possible options.

   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 Medic value.

To filter table records by the explicitly specified numeric value

1. Click the grey cell below the Selling Price column title and type in specific numeric value (7) 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 7.

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 a less than condition (<7).

   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 (<7).

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

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 below the column title and type in true or 1 if you want to filter by the enabled records, and false or 0 to show the disabled records.

   

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

How can we improve this article?

Send