Simple search

When opening a filter by default simple search in enabled. In the simple search are the most searched columns visible in the top. These search options can be used to filter result in the filter.

Adding search options

When the default search options aren't exactly what is need you can add extra field via the button 'Search fields'. Select the required fields and click on the the confirm button (check mark right of the button).

Search types

There are four different types of search types

Lists
When a list search is available one or more selections can be made by checking the checkboxes. In the top of the search field there is the possibility to do a text search.

Text
In the text search there are two possibilities: contains [~] and equals to [=].

Example

 contains [~] frans

Results in:
1. frans
2. franssen
3. etc.

 equals to [=] frans

Results in:
1) frans

Numeric

In the text search there are four possibilities: equals to [=], greather than [>], less than [<] and range.

Example

 customerid is equal to [=] 122

Results in customer with id 122

 customerid is greater than [>] 130

Results in customers with id's larger than 130

 customerid is less than [<] 110

Results in customers with id's smaller than 110

 customerid range 200 till 250

Results in customers with id's larger than 200 and smaller than 250

Date

In the date search there are five possibilities:
1) date range, here you can select a from and end date
2) started within the next [predefined values]
3) started within the next x days
4) started more than x days in the feature
5) in range from, here relative dates can be used

Example date range

 1w 2d 5h 30m

Where w = weeks, d = days, h = hours, m = minutes.
If the field starts with a '-', it is treated as a time in the past, for example, '-1w 3d' is "10 days ago".
An unset field denotes unbounded, so if from is blank, and to is -1d, this means "everything earlier than 1 day ago".