Versions Compared

Old Version 1

changes.mady.by.user Bärbel Neitzel

Saved on

compared with

New Version 2

changes.mady.by.user Sabrina Stelter

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Contents

Table of Contents

Related

...

page

...

Available search operators

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

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:

m1Next accounting period, next service month
m-1The last accounting period, last service month
>=m1Less than / equal to the next accounting period / service month
m-6:m6Last 6 accounting periods/service months up to next 6 accounting periods/service months.


Linking multiple search operators

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.