Custom filter
The Custom filter link in the dropdown menu of the table column header displays a box for entering a filter expression instead of the list of the column values. You can switch the filter back by clicking on the Value selection filter link.
The filter expression consists of:
- literals
- logical operators
- relation operators
- mathematical operators
For example, use the following expression in the Service column to only display tickets in the IT and HR services on the Tickets page:
"IT" or "HR".
You can use the following logical operators:
- and
- or
- not
Text literals
Text literals are case-insensitive and accent-insensitive, i.e., the "Alvao" literal matches ALVAO, alvao, Alváo, etc.
But it doesn't match values with extra characters, like ALVAO application, etc.
Use asterisk to match any number (including zero) of arbitrary characters:
"Alvao*"- matches ALVAO application"*Alvao*"- matches Install the ALVAO application
If the filter expression only consists of one text literal with leading and trailing asterisks, you can omit the quotation marks and asterisks. E.g., the Alvao expression is interpreted as "*Alvao*".
Relational operators
You can use a relation operator in front of a literal.
E.g., assuming a column has numerical data type, the <100 expression displays row with numerical values lower than one hundred.
If no relational operator is used the = is applied by default. E.g., the 100 expression is interpreted as =100.
You can use the following relational operators:
- >
- <
- =, ==
- >=
- <=
- !, not, <>, !=
Boolean literals
Use the 1 and 0 literals for columns of bool data type.
You can also use the yes and no literals, but they depend on current UI language and will not work after you change you preferred language in the app.
Date and time literals
For the date and time data type columns, specify dates in the international format: yyyy-mm-dd. E.g., 2026-05-26.
If you need to also specify time, use the yyyy-mm-dd hh:mm format, e.g, 2026-05-26 17:00.
Using dynamic variables, like @now and @today, could be more convenient in some scenarios:
| Variable | Description |
|---|---|
| @now | The current date and time with precision on one hour. You can add or subtract constant number of hours. E.g., the <@now+10 expression means in 10 hours or earlier. |
| @today | The current date regardless time. You can add or subtract constant number of days. E.g., the >@today-10 expression means in the last 10 calendar days or later. Dates are calculated calendar-wise regardless service operating hours, weekends, and holidays. |
You can also use asterisks on specific places of date literals.
The 2026-05-* expression means May, 2026.
Analogically, the 2026-*-* means entire year 2026.
Examples
- Today's data:
@today - Data for the last 30 days:
>=@today-30 - Data from tomorrow:
=@today+1 - Data over the next 3 days:
>@today and <=@today+3 - Data from the next 5 hours from now:
>@now and <=@now+5 - Data from January to May 2026:
>=2026-01-01 and <2026-06-01 - Data from October 5 and 7, 2026:
=2026-10-05 or =2026-10-07
Tickets - @me variable
The @me variable represents the name of the currently logged in user.
The @me filter expression can be used in the following table columns: