Dependencies - Filter expression properties

Join

Multiple filter expressions are linked together with "Join". With an AND join, only data records that fulfill all criteria are returned. With an OR join, data records are returned that fulfill at least one of the criteria.

Data field to be filtered

Available

You can see the application structure with all data fields here.

Selected

Here, you can see all data fields whose value should be compared with the value of the triggering control. In the "Data group" column, the data group, where the data field originates, is shown.

Move a data field from one list to the other.

All values must match the condition / At least one value must match the condition

When comparing multiple data fields, you can specify whether all or at least one of the data fields should match the filter expression.

Interpret as interval

This option is available if the comparison is to be made using the dynamic filters “Value range” or “Calendar”. In this case, the interval must overlap or touch the range to be filtered. For example, if a start date of 12/1 and an end date of 12/5 are specified for filtering tasks, the "Interpret as interval" setting will return all tasks that were started before 12/1 and completed in the defined time period, and all tasks that were started in the defined time period and completed after 12/5.

Please note when filtering time periods that a day always begins at 00:00. So if you want to filter the period 8/1 to 8/5, the filter expression must be >8/1 and <8/6 so that 8/5 is still included in the filter.

Operation

Select the desired Operator.

Negation

If this setting is selected, all data, which does not meet the criteria, will be returned as the result.

Comparative value

Select the control that contains the comparative value.

Primary key

Primary key Compares the data field's value with the LID of the data record.

Displayed value

Performs a comparison with the displayed character string in the triggering control.

Saved value

This setting compares the data field's value with the LID of the data record.

Day search

If a word cloud is selected as the triggering control, clicking on a day will trigger a search for containing posts and filter the element concerned (e.g. a table) accordingly.

Search in index

This option allows data fields with the "Integer" or "String" data type to be compared with input fields with the "Text" control type. If the comparative type "Search in index" is selected, a search configuration and a comparative field must be specified. The text from the control, which is selected in the area "Comparative value", will be transferred to the search configuration. Afterwards, the search result will be returned. Finally, the operator "Is contained in", which is the only possible operator for index search, is checked as to whether the value of the data field to be filtered is contained in the result list. If this is the case, the corresponding data record is shown.

Edit index search

Opens a dialog where the search configuration can be selected.

Compare data field

If the selected control is an “Operator” ആ filter element, you can select the data field whose values should be compared here.

Boolean values

For a comparison with the “Boolean values” filter element, the mode for the effect that selecting the checkbox has in the browser can be specified.

  • Exclusive

    With this setting, only the data records that have the same status as the checkbox of the filter will be shown.

  • Negative selection

    With a selected checkbox, all data records will be shown. If the checkbox is not selected, the records will be shown that have the value "false".

  • Positive selection

    With a selected checkbox, only the data records will be shown that have the value "true". If the checkbox is not selected, all data records will be shown.

  • Positive exclusive

    For a selected checkbox, only the sets will be shown whose value is "false". If the checkbox is not selected, all data records will be shown.

    Subquery

    This comparison value can be selected in combination with the operators "Is contained in" or "Is not contained in" and also with dependencies.

    Edit subquery

    Opens a dialog where the subquery for a data group can be defined.

More information

Dependencies
Filters