Using Filters

You can customize the display of information in the tables according to a given filter. To enter the filter conditions, click

https://slite.com/api/files/-Q2jFOLzJduSGT/filter.png?apiToken=eyJhbGciOiJIUzI1NiIsImtpZCI6IjIwMjMtMDUtMDQifQ.eyJzY29wZSI6Im5vdGUtZXhwb3J0IiwibmlkIjoiVVhXTkZNZl8xNzNJaXIiLCJpYXQiOjE3MzIyMTU2MjYsImlzcyI6Imh0dHBzOi8vc2xpdGUuY29tIiwianRpIjoiZU0xeXUxeTRBWGxsZ1UiLCJleHAiOjE3MzQ4MDc2MjZ9.DbxrJ7FRWT4s4Y4dnMO3uSj49xIPP4r2DHJ_aUsREq8
In the header of the column with the required parameter.
If a parameter can only assume certain values, you can select one or more values from the list. For example, to display tasks with certain statuses.

https://slite.com/api/files/jIkcnma2Bp6xWl/an-example-of-a-filter-for-a-task-list.png?apiToken=eyJhbGciOiJIUzI1NiIsImtpZCI6IjIwMjMtMDUtMDQifQ.eyJzY29wZSI6Im5vdGUtZXhwb3J0IiwibmlkIjoiVVhXTkZNZl8xNzNJaXIiLCJpYXQiOjE3MzIyMTU2MjYsImlzcyI6Imh0dHBzOi8vc2xpdGUuY29tIiwianRpIjoiZU0xeXUxeTRBWGxsZ1UiLCJleHAiOjE3MzQ4MDc2MjZ9.DbxrJ7FRWT4s4Y4dnMO3uSj49xIPP4r2DHJ_aUsREq8
If the parameter can assume different values, specify the filter conditions using special syntax.

https://slite.com/api/files/Q24PjdNygQ9EMA/example-of-a-filter-to-search-by-name.png?apiToken=eyJhbGciOiJIUzI1NiIsImtpZCI6IjIwMjMtMDUtMDQifQ.eyJzY29wZSI6Im5vdGUtZXhwb3J0IiwibmlkIjoiVVhXTkZNZl8xNzNJaXIiLCJpYXQiOjE3MzIyMTU2MjYsImlzcyI6Imh0dHBzOi8vc2xpdGUuY29tIiwianRpIjoiZU0xeXUxeTRBWGxsZ1UiLCJleHAiOjE3MzQ4MDc2MjZ9.DbxrJ7FRWT4s4Y4dnMO3uSj49xIPP4r2DHJ_aUsREq8

Filter syntax


https://slite.com/api/files/7eSURTWaUcaFfg/link-solid.svg?apiToken=eyJhbGciOiJIUzI1NiIsImtpZCI6IjIwMjMtMDUtMDQifQ.eyJzY29wZSI6Im5vdGUtZXhwb3J0IiwibmlkIjoiVVhXTkZNZl8xNzNJaXIiLCJpYXQiOjE3MzIyMTU2MjYsImlzcyI6Imh0dHBzOi8vc2xpdGUuY29tIiwianRpIjoiZU0xeXUxeTRBWGxsZ1UiLCJleHAiOjE3MzQ4MDc2MjZ9.DbxrJ7FRWT4s4Y4dnMO3uSj49xIPP4r2DHJ_aUsREq8
You can use special characters in filters:
Sympol
Meaning
Comment
""
exact query
for text only
*
any number of characters
-
%
any number of characters
-
?
any single character
-
_
any single character
-
&
logical “AND”
-
,
logical “OR”
-
|
logical “OR”
-
!
logical “NOT”
-
<
smaller than
for numbers only
<=
smaller or equal to
for numbers only
>
greater than
for numbers only
>=
greater or equal to
for numbers only
-
range
for numbers only
Note
Special characters are not used in the following filters:
* IP addresses in the VM list;
* IP addresses in the list of VMs contained in a high availability cluster;
* tags in the script list;
* tags in the OS list.
One filter can include several special characters. For example, filter >100&*6 will display all values that are greater than 100 and end in 6.
If you enter a value without special characters in the filter:
  • for text parameters — the list will be filtered by the occurrence of this value. For example, filter VM1 will display the values of VM1, VM12, My VM1, etc.;
  • for numeric parameters — the list will be filtered by the exact value. For example, for filter 29, only the value 29 will be displayed.
If symbols for the logical "AND", "OR", and "NOT" are inside quotation marks, the filter treats them as normal characters. For example, the filter "drag&drop" will display the drag&drop value.