...
| Operator | Symbol | Effect | Note | Example |
|---|---|---|---|---|
| uneven |  | Your entry will be excluded from the searched data. | Excludes exactly the item you specify. | We are looking for all invoices created in 2016 that have an amount over 500€ and the article 'Greenfee WE 18-Hole' does not appear:
|
| less or equal |  | Refers to the'Date' field. | Anything less than or equal to your entry will be displayed in the data you are looking for. | For example, you are looking for all invoices in 2014 that have a smaller total discount of 50€:
|
| smaller |  | Refers to the'Date' field. | Anything smaller than your input will be displayed in the data you are looking for. | For example, you are looking for all invoices in 2014 that have a smaller total discount of 50€:  |
| is not definednull |  | In this field there is no input possibility, since you would like to have indicated whether this field is "empty". | The selected column is filtered by empty fields See column Example → | All ladies with an ÖGV-ID and without an existing e-mail address:  members' invoices which are not yet paid (payment date is not defined)  |
| is not null |  | There is no input option in this field, since you want to see whether this field is "filled". | The selected column is filtered by filled fields See column Example →  | All male members with Nexxchange Id (Nexxchange Id is defined)
|
greater or equal |  | Refers to the'Date' field. | Anything greater than or equal to your entry will be displayed in the data you are looking for. | All members who have received an invoice on 21.10.2016, or later:  |
| greater |  | Refers to the'Date' field. | Anything larger than your input will be displayed in the data you are looking for. | We search for all invoices created in 2016, an amount greater than 500€ and the article'Greenfee WE 18-Hole' does not appear:
|
| equal |  | The result corresponds exactly to your entry. | Here we pay close attention to the spelling! Helps you to search exactly for the desired search and to filter out undesired information. | Search all articles named 'Test Article 1':  |
| does not contain |  | As soon as a part of your input is included in the data you are looking for, it is now excluded. | If you are looking for a certain "group" of persons / invoices / articles for which something should be excluded, this operator is a great help! | Display all invoice items that have been cleared since 01.01.2016 and do not contain articles with "ÖGV":  |
| contains |  | Your entry can be part of the actual value you are looking for. | This is only recommended if you do not need to make any further specifications. Can also be any part of the item/customer/invoice. | The search for'Max Mustermann' :'Muster','Max','mann' would suffice e.g. for the desired result:
|
| ends with |  | Your entry refers to the last value. | Is the opposite of the search 'begins with'. This time the search refers to the last value included. | To find the article'Annual game fee youth over 14' with this operator, you must enter letters from the last word/number: e.g. 1, 4 or 14 |
| begins with |  | Your entry refers to the first word in your search. | Helpful when searching in which several values are included and only the beginning is known to you. | To find the article'Annual game fee youth over 14' with this operator, you must enter letters from the 1st word: e.g. year, annual game, annual game fee etc.. |
...