Skip to main content

Set filters

Filters allow you to exclude irrelevant parameters in advance and cut down on loading times. Filters can determine time ranges, exclude rejected segments, omit advance invoices exclude cancelled events and much more. Well-targeted filters are essential for self-searching lists (SSL).

Example: Search for booked items from a specific period.

    1. Select the line of the date reference in the list.
    2. Enter the filter operator Value between .
    3. Enter a From date.
    4. Enter a To date.
    5. Speichern Save your input by clicking on the icon in the top left-hand corner of the input window.
    6. Click on Ausfuehren Test list in the toolbar to verify your list results

 

Further filter options:

Greatest values
 Use for numbers, shows the largest value
Smallest values

Use for numbers, shows the smallest value
Value equals

Filters for text, number or Boolean value with one or more conditions depending on the references

Example:
Show only accounts with the category private account (truth value): Result: Value equal to > X
Show only events with the status "Confirmed: Result: Value equal > Confirmed
Value greater than
 Filter for values greater than a given size
Example: Number of guests greater than 99 (show as of 100 guests)
Value greater than or equal to

Filter for values greater than or equal to a given size
Example: Number of guests greater than or equal to 100 (show as of 100 guests)
Value less than

Filter for values smaller than a given size
Example: Sales smaller than 100 Euros, show values up to 99 Euros.
Value less than or equal to

Filter for values smaller than or equal to a given size
Example: Sales smaller than or equal to 100 Euros, show values up to 100 Euros.
Value not equal to

Exclude text or number
Example: Don't show events with status "On hold"
Value between

Shows values between the operators, see example above