The following commands can be useed to filter tables:
| Command |
Explanation |
Example |
Applicable to |
| ! |
Show all except the search term |
"!Müller" |
Text |
| = |
Display only rows which match the search value exactly |
"=Müller" |
Text |
| OR |
Append mulitple seach terms |
"Müller OR Maier" |
Text |
| ? |
Filter by empty columns |
"?" |
Text |
| > |
Alle Datensätze nach gewähltem Datum anzeigen |
"> 01.10.2023" |
Date |
| < |
Display columns with a date before the search value |
"< 01.10.2023" |
Date |
| - |
Filter a date column by a date range |
"01.10.2023 - 31.12.2023" |
Date |
| h |
Today |
"h" |
Date |
| g |
Yesterday |
"g" |
Date |
| m |
Tomorrow |
"m" |
Date |
| v |
Filter a date column by the day before yesterday |
"v" |
Date |
| ü |
Filter a date column by the day after tomorrow |
"ü" |
Date |
| lw |
Display rows from last week |
"lw" |
Date |
| lj |
Display rows from last year |
"lj" |
Date |
| < |
Show values smaller than the search value in numeric columns |
"< 300" |
Numbers |
| > |
Show values greater than the search value in numeric columns |
"> 300" |
Numbers |
| ja, true, 1, x, y, yes |
Filter boolean columns by 'true' |
"j" |
Boolean columns (yes/no) |
| nein, false, 0, n, no |
Filter boolean columns by 'false' |
"n" |
Boolean columns (yes/no) |
