General information regarding 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.
Moves 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
The option Interpret as interval 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 1/12 and end date 5/12 is 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 0: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
The setting Saved value compares the data
field's value with the LID of the data record.
Day search
If a Wordcloud
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 filtred 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 the filter control Boolean Values,
the Mode can be defined for the effect that marking
the checkbox in the browser should have. The following settings are
possible:
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 valus 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.
Here, you'll
find further information on this topic.