Skip to main content

Filter

Using a filter, you can display only rows in a table that meet a certain criterion. You can find the commands to work with the filter in the local table menu and also in the local header menu.

Advanced filter​

If the filter is enabled, you can manually change its settings in the row below the header. If you enter text in a column, only the rows whose value in that column contains the specified text will be displayed in the table. When comparing values, diacritics are ignored. The asterisk represents any number of arbitrary characters, so if you enter, for example, "ar", the filter will only pass values that contain the substring "ar". Entering "*ar*" would have the same result, because the asterisk is added automatically at the beginning and end. Another option is to enter a boolean expression into the filter, such as "*ar*" or "*unk*".

Searched parts of the text must be enclosed in quotation marks. The following logical operators may be used in the expression:

  • and
  • or
  • not

The keywords listed in the following table can only be used in column filters with Yes/No (boolean) values:

Keyword
yes / yes
no / no

For columns of type text, number and date and time it is possible to use mathematical operators em> ">" (greater), "<" (less), ">=" (greater than or equal to), "<=" (less than or equal to), "!,Not,<>,!=" (negation, not, not equal to), "=,==" (equal to). The alphanumeric order of the texts is assumed when comparing them.

Filter above columns of type "date and time"​

If the column is of type "date and time", the following filter write options are supported:

  • @now - displays entries from today's date and current time to the nearest hour.
  • @today - displays entries from today's day only.
  • *.M.YYYY - displays data from month M and year YYYY
  • *.*.YYYY - displays data from year YYYY
  • D.M.YYYY - displays data from a specific day D.M.YYYY
  • D.M.YYYY H - displays data from a specific day D.M.YYYY and hour H
  • D.M.YYYY H:M - displays data from a specific day D.M.YYYY and hour H and minute M
  • operators:
OperatorDescriptionExample of use
<, >, <=, >=smaller, larger, less than or equal to, greater than or equal to>15.4.2025
=, ==equals=15.4.2025
!=, <>not equal<>15.4.2025
Not, !does not (same meaning as does not equal)Not 15.4.2025
and, orlogical product and logical sum=15.4.2025 or =16.4.2014
note
  • Date formats D.M.YYYY, D.M.YYY can be written to the filter. M/D/YYYY and YYYY-M-D, the date separator can be followed by a space, the day and month digits can be written as single or double digits, the year must be written as a 4-digit number.
  • If the AND or OR operator is used, some mathematical comparison operator (e.g. =) must also be specified.
  • An integer representing the number of hours can be added/subtracted to the @now variable. The resulting time is calculated regardless of service hours, weekends and holidays. E.g. @now+10 means: in 10 hours.
  • An integer can be added/subtracted to the @today variable to represent the number of days. The resulting date is calculated on a calendar basis, regardless of service hours, weekends and holidays. E.g. @today-1 means: yesterday.

Examples​

  • Today's data: @today
  • Data for the last 30 days: >= (@today - 30)
  • Data from the following day: = (@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 as of 4/14/2025: 14.4.2025
  • Data from 2025: *.*.2025
  • Data from January to May 2025: >=1.1.2025 and <1.6.2025
  • Data from October 5 and 6, 2025: =5.10.2025 or =6.10.2025

Variable @me​

The @me variable represents the name of the currently logged in user. You can use it to filter out records related to the currently logged in user. This variable is available in the ALVAO Service Desk:

  • Tickets - in the Requester and solver columns
  • Diary - in the From, To, Created by, Solver, Requester columns
  • Ticket log table (bottom left) - in From, To, Created by columns