Filtering and sorting data records

If you have chosen the action "Read multiple data records" in the dialog step "Data group selection", you will be taken to the dialog step "Filters and sorting" after defining the query parameters.

  1. Click on the icon.

    The relevant fields are described below.

    Join

    If you create multiple filter expressions, the type of "Join" is selectable. An "AND" linking will return only data records that fulfill all criteria, and an "OR" linking will return only the data records that fulfill a minimum of one criterion.

    Data group

    Select the data group to which the query parameter should be assigned here.

    Data Field

    Select the data field to be assigned to the query parameter here.

    Operation

    Select the operator here. Depending on the type of data field selected, the following operators are available:

    Detailed information on this can be found in the section 2. Operation

    Negation

    This setting can be activated for the operators "Contains", "Begins with", and "Ends with". This will identify all data fields that do not match the filter.

    Detailed information about the "Filter Expression Properties" dialog can be found in the section Filter.

  2. Select the "Binding" option.

  3. Click on the .

    The "Binding properties" dialog appears.

    Select the "Parameters (Application API)" option on the left.

    Select the desired parameter on the right below "Parameter (Application API)".

    Click on "OK".

    You will be returned to the "Filter expression properties" dialog.

    Click on "OK".

    You will be returned to the "Filter and sort" dialog step.