Filter - Operator

The "Operator" element belongs to the "Filter" element category.

This filter can be used, for example, to compare a view table that is linked to the filter via a dependency with an operation.

Three fields are available in the filter:

  1. Selection of the data field whose values are to be compared

  2. Operator

  3. Value for which the table is being filtered

 

The "Operator" filter can be found in the "Applications" module in the "Elements" area. A new filter can be created by positioning the element on the workspace from here using drag & drop.

All information for creating elements can be found here.

The properties dialog of the filter opens automatically when a new filter is created. The properties dialog of an existing filter can be opened by double-clicking on the element on the workspace, via the "Properties" context menu or via the "Edit / Properties" main menu if the filter is selected on the workspace.

Properties "Operator" filter

General

Provide the filter with a title here. Information on multilingual titles can be found here.

"Adapt to maximum available width" causes the element to be adapted in width to the next element surrounding it.

Comparison

Operator

Select the comparison type here.

Application / Data group

Select the application and data group that contains the data that should be compared with the data of the element to be filtered.

Data Field

Here, the data fields are defined that will be shown in the first drop-down list in the browser.

Available

This list displays all of the data fields that can be selected for the filter.

Selected

This list displays all of the data fields used in the filter.

The checkbox to the left of a data field selected here can be selected if the setting "Show list with data fields" is set on the "Other" tab. The data field is then displayed as already selected in the selection list in the browser.

Moves an entry from one list to another.

Format of the filter element

Select the desired control type for display in the browser here.

The format should match the data type of the data field that is filtered in the dependent element.

The filter only accepts values in the browser that correspond to the format selected here.

If the format is a date format, a small calendar is displayed below the control when entering in the browser, from which the date or time can be conveniently selected.

Misc

Show list with data fields

This option shows the drop-down list in the browser that the user can select a data field from.

Allow multiple selection

Allows the selection of multiple data fields in the drop-down list in the browser for the comparison.

With this setting, the filter element should be created at the appropriate height so that all entries are visible in the browser.

  • All values must fulfill the condition

    With this option, a result is only obtained if the value entered in the filter for comparison can be found in all fields selected in the browser.

  • At least one value must fulfill the condition

    Returns a result if the value entered as a comparison was found in at least one data field.

Show list with operators

This option shows the operators list in the browser.