How to configure Filters in a List?
Hi there!
Today, I'll show you an example how to configure filters in listviews resp. calendarlistviews. For example, we want to differentiate between all projects, next projects and critical projects by adding filters. In crmclient online, we provide the field "Search", where you can configure filters.
You can add a filter by simply giving the name of the filter and stating the SQL statement. Please be aware that you have to separate the name of the filter and the SQL statement with a semicolon. In the following, I'll show you the pattern for generating filters:
Alle; NameOfFilter1; SELECT ... FROM ... WHERE ...; NameOfFilter2; SELECT ... FROM ... WHERE ...; ...
The keyword Alle indicates that all elements you selected in your normal SQL statement are shown in the first filter section. After this section you can start with your new filters.
After configuring the app, your filters are available in the list after clicking the upper right eye button, which is just visible if filters are defined.