Dependencies - Filter expression properties
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
You can see the application structure with all data fields here.
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.
Select the desired Operator.
If this setting is selected, all data, which does not meet the criteria, will be returned as the result.
Select the control that contains the comparative value.
Primary key Compares the data field's value with the LID of the data record.
Performs a comparison with the displayed character string in the triggering control.
This setting compares the data field's value with the LID of the data record.
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.
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.
With this setting, only the data records that have the same status as the checkbox of the filter will be shown.
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".
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.
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.
This comparison value can be selected in combination with the operators "Is contained in" or "Is not contained in" and also with dependencies.
Opens a dialog where the subquery for a data group can be defined.