Dependencies - Filter expression properties

Applications module Example: View table Properties Dependencies tab / Add dependency Dependency properties / Add new filter expression


General information about dependencies can be found here.

1. 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.

2. 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 should be made with the dynamic filters Value range or Calendar. With this, the interval must overlap or touch the area to be filtered. If, for example, the start date "01/12" and end date "5/12" are specified for filtering tasks, the setting "Interpret as interval" interprets all tasks that start before the 1/12 and are completed within the specified time; plus all tasks that were completed after the 5/12 and started within the specified time.

Please note when filtering time periods that a day always begins at 00:00. If you would like to filter the period of 01/08 until 05/08, the filter expression must be ">01/08 and <06/08". so that 05/08 is 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.

3. Comparative value

Select the control that contained the comparative value.

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 the search for containing posts and the affected element (e.g. a table) will be filtered accordingly.

Search in index

Data fields with the data type integer or string can be compared to edit fields with the control type "Text". If the comparative type "Search in index" is selected, a search configuration and a comparative field must be specified.

Edit index search
Opens a dialog where the search configuration can be selected.

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.

Compare data field

Select the data field whose value should be compared.

Boolean values

For a comparison with this filter control, the "Mode" can be defined for the effect that marking the checkbox in the browser should have. The following settings are possible: Click here for more information on this subject.