Available search operators

Character name	Character	Keyboard shortcut	Description / example

Character name	Character	Keyboard shortcut	Description / example
Pipe	\|	Alt Gr + <	Meaning: Or Example: BRE\|MUC - Search for BRE or MUC (Use the code when editing the search fields. The name can only be evaluated if the code entry is entered in capital letters.) 15/02/2015\|16/02/2015 - Search for 15/02/2015 or 16/02/2015
Greater	>	Shift + <	Meaning: Greater than Example: >28/02/2015 – Search for a date after 28/02/2015
Less	<	<	Meaning: Less than Example: <01/02/2015 – Search for a date before 01/02/2015
Equal	=	Shift + 0	Description/use: Cannot be used on its own, only in combination with other characters.
Current date	t	t	Meaning: Converted into the current date. Example: The entry t in a date field is converted into e.g. 14/01/2015. The results only shows data from 14/01/2015. t1 is converted into tomorrow's date, t-1 into yesterday's date.
Asterisk	*	Shift + +	Meaning: Placeholder Example: Search for BR* shows results for BRE. Search for *R* shows results for BRE and FRA.
Colon	:	Shift + .	Meaning: from:to Example: Search for 01/01/2015:31/01/2015 delivers all results from January.

Combined search operators

Operator	Character	Description / Example

Operator	Character	Description / Example
Greater than or equal to	>=	Greater than or equal to Example: >= 15/02/2015 - Search for a date greater than or equal to 15/02/2015
Less than or equal to	<=	Less than or equal to Example: <= 15/02/2015 - Search for a date less than or equal to 15/02/2015
Current date	=t	Meaning: Is NOT converted to the current date. Explanation: When using =t, the application determines the current date anew every day. =t is not visually converted into a date. Example: On 23/01/2015, =t only shows datasets from 23/01/2015. On 24/01/2015, =t only shows datasets from 24/01/2015.
Current month	=m	Similar to the [t] function for entering the date, the abbreviation [m] can be used in the accounting period or in the service month. Enter [m] to preallocate the actual valid accounting period or the service month. Example: In the dashboard, a search area can be constructed over the last 6 booking periods as follows:

Operator	Description / example

Operator	Description / example
t-1\|t\|t1 - or - t-1:t1	Meaning: yesterday, today, tomorrow Example: Using t-1\|t\|t1 on 15/02/2015 willl show results from 14/02/2015, 15/02/2015 and 16/02/2015. Alternative: t-1:t1 – Search across the same period.
t-7:t7	Meaning: Previous week - one week in the future
BRE\|FRA\|MUC	Meaning: Search for BRE or FRA or MUC
>t-1:t2	Meaning: Previous day - 2 days in the future
>=t	All dates as of and including today.