Filters on the list view form

Если для даты значение в поле фильтра и значение в поле атрибута имеют разный формат, то фильтр по такому полю работать НЕ БУДЕТ

The query for the filter is specified by an expression (search query).

The available operations:

  • using brackets for grouping
  • logical: AND, OR, NOT
  • comparison: =, <, >, <=, >=, <>
  • arithmetic: +, -, *, /
  • string: like
  • over collections: size

Create a query

Choose attribute from the drop-down list using the > _button located at the bottom of the filter request field. The name of the attribute is shortened in “backticks” i.e.:

`Наименование атрибута` != 2

Combination options of attribute values for a query:

  • and - necessarily both (or more) values,
  • or - any of the values of both (or more) values.

Example of a combination:

`Атрибут1` = 1 AND `Атрибут2` != 2

String values of attributes when forming the request, are wrapped in double quotes:

`Название поля` != "привет"

Accessing attributes by reference:

`Атрибут1`.`Атрибут по ссылке из Атрибут 1` = "значение"

Hints:

At the end of the filter query field, there is a ?sign, when clicked, a model window opens describing how the filter and the query syntax for it works.

This library (https://nearley.js.org/) is used to parse search expressions.

Options for using

In addition to the button next to the search bar at the top of the page, you can call the filter by clicking on the similar icon located in each column of the table.

To create a request for the filter, select a value from the drop-down list, or start typing a value in a row. As soon as the value is selected, you need to press the Enter key - the result of the query is displayed in the value column.