Customizing filters

With the Adjust filter function, you can define comprehensive filter settings.

 
Note

Certain filter conditions cannot be applied if a mobile app is used in offline mode. This includes the link conditions, complex queries in expert mode, and all date jokers excluding: current week, current week+?, current week-?, yesterday, yesterday+?, yesterday-?, today, today+?, today-?, tomorrow, tomorrow +? and tomorrow-?.

The adjustments are available in two modes, the Standard mode and the Expert mode.

Function

Description

Default mode

If you click the Adjust filter button, you open the default mode.

In the default mode, you can define the same settings as in a view filter.

SmartWe Online Help: Filter

Expert mode

You select the expert mode via the button.

In the expert mode, you can define your filter conditions via a code.

  • For the filter criteria, you use the field names as defined in the Data record types area.
  • Possible relational operators: =, !=, <, >, <=, and >=
  • You can create chains of operators by using: and or or.
  • You can compare all fields with the following data types: string, boolean, decimal, and int.
 
Example

You would like to filter all tasks which have a value entered in the Priority field and which have not yet been completed. To do so, enter the following code:

Copy
PRIORITY != '' and WORKINGPERCENT < 100

For the Linked data records data source, you can add target to the field name:

Copy
target.PRIORITY != '' and target.WORKINGPERCENT < 100