Anwendung wechseln:
| 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 |
| > | Display columns with a date after the search value | "> 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) |