Filter definitions

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

First, select the data group, from which the values are to be filtered. The filter can also use data fields from a higher or lower data group level, i.e. parent or child data groups.

Data field

Select the data field or reference field whose values should be compared to the selected operation with the comparison value corresponding.

Operation

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

Data type: string, longtext

Operator

Delivers

Operator

Delivers

Equals

Every string that is identical with the comparative value. This is case-sensitive.

Unequal

Every string that is not identical with the comparative value. This is case-sensitive.

Less than or equal

Every string with a smaller or equal character values (ASCII) as the comparative value.

Less than

Every string with a smaller character values (ASCII)as the comparative value.

Greater than or equal

Every string with a greater or equal character values (ASCII) as the comparative value.

Greater than

Every string with a greater character values (ASCII) as the comparative value.

Undefined

Every data record whose data field does not contain a valid value or has not yet been initialized. A comparative value does not need to be defined for this operator.

Defined

The data field contains any random value. An empty string is also valid - e.g. when saving without an entry. A comparative value does not need to be defined for this operator.

Contains

All string that contain the comparative value.

Starts with

All string that contain the comparative value.

Ends with

All string that end the comparative value.

Is contained in

All strings that appear, even in part, in the comparative value. If the string delivered by the data fieldis identical to the comparative value, no result will be returned. Multiple values can be separated with ||.

Is not contained in

All strings that not appear, even in part, in the comparative value. Multiple values can be separated with ||.


The operators "Less than or equal", "Less than", "Greater than orequal", and "Greater than" offer special usefulness when filtering customer or product numbers that are made up of number and letter strings. With the number "C1000" the ASCII value of the character string can deliver smaller numbers. The capital letter "C" has an ASCII value of 67, the number "1" has the value 49, and the number "0" has the value 48. The operators named above compare ASCII values lexicographically. With the operator "Less than", all numbers that are smaller than "C1000" will be returned ("C999, C998, "etc.). In order to deliver data sets that possess no entry in the data field, a query must be made with an "OR" link, i.e. whether the value of the field is "NULL" (operator: "Undefined"), or whether the entry is empty because no entry has been saved. In order to return an empty string, select the operator "Equals" and set the comparison value to "User-defined". The "Character string" field will remain empty in this case. If all fields will be filtered to return entries (no empty string and no "NULL"), the filter must be run in this way with an "AND" linking.

Data type: integer, float, datetime

Operator

Delivers

Equals

Equal values

Unequal

Unequal values

Smaller than, or equal

Smaller or equal values

Less than

Smaller values

Exceeding, or equal

Exceeding or equal values

Exceeding

Exceeding values

Undefined

Every data set whose data fielddoes not contain a valid value or has not yet been initialized. A comparative value does not need to be defined for this operator.

Defined

The data field contains any random value. A comparative value does not need to be defined for this operator.

Is contained in

The same as operator "Equals"

Is not contained in

The same as operator "Unequal"

Is contained in tenants

Is only available for selection if the UserID or a GUID from the Users application has been selected as the data field. It can be compared with the system values "Selected tenants of current user" and "All tenants of current user" to filter the current data by the tenant(s) that area assigned to the current user. Click here for more information.


Data type: boolean

Operator

Delivers

Equals

Equal logical value

Undefined

Fields with the value "NULL"

Defined

Records in which the data fieldhas either the value "True" or "False".

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. This will identify all data fields that do not match the filter.

Comparison value

Data field

Here, a data or reference field of your choice can be chosen for comparison. Comparing fields is only possible with fields of the same data type. Comparing fields is only possible with fields of the same data type.

Current value

Returns every data record that contains the current value of the selected data field from the specified ReadContainer.

Select a data field from a parent data group

Opens a dialog where data fields from a parent data group can be selected. This button is only available if the data group, which is used in the selected ReadContainer and has a parent data group (or higher).

Current user - Comparison with an integer data field

  • User ID

    Compares the ID of the current user for example for showing the records created by the currently logged-in user.

  • Gender

    Compares with the gender of the currently logged-in user.

  • Deputy ID

    Together with the operator "Is contained in", a list of the deputy IDs of the current user will be delivered.

  • Superior ID

    Together with the operator "Is contained in", a list of the superior IDs of the current user will be delivered.

Current user - Comparison with other data types

If a data field is selected that does not have the type integer, a comparison can be made here with the corresponding fields from the User manager.

System value

  • Data record ID

    The selected data field will be compared with the ID of the currently displayed data record.

  • Parent data record ID

    The selected data field will be compared with the ID of the superordinate data record.

  • Request value

    Compares the data field with the value of a request variable that is entered here.

    • Value

      Enter the name of the request parameter here.

    • Default

      Enter the default value that should be used for null values.

  • Session value

    Compares the data field with the value of a session variable.

    • Value

      Enter the name of the session variable here.

    • Default

      The default value is used when the session variable is not defined.

  • Processing context

    Compares the data field with the value of a variable from the processing context.

    • Value

      Enter the name of the variable here.

    • Default

      The default value is used when the variable is not defined.

  • Set

    In combination with the operator "Is contained in", this delivers data records from users who are contained in the set. Only users are retrieved, other objects like user groups are not.

    • Set

      Select the desired set.

  • Container

    In combination with the operator "Is contained in", this delivers data records from users who are contained in the container.

    • Container

      Select the desired container.

  • Selected tenants of current user

    In combination with the operator "Is contained in tenants", this returns the records that are contained in the tenants selected by the current user. Click here for more information.

  • All tenants of current user

    In combination with the operator "Is contained in tenants", this returns the records that are contained in every tenant assigned to the current user. Click here for more information.

System value - Comparison with a datetime data field

If the selected data field is a datetime data field, the value of that field can be compared with the current date. You can find out more about adjusting dates here.

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.

System value - Comparison with a string or text data field

String or text data fields can be compared with the system value "exchange mailbox info". The following values are available: The following values are available:

  • INBOX
    (HRef of the folder inbox)
  • USERMAILADDRESS
    (Email address of the exchange user)
  • USERMAILBOX
    (Mailbox of the exchange user)
  • DRAFTS
    (Href of the folder drafts)
  • DELETEDITEMS
    (HRef of the folder deleted items)
  • SENTITEMS
    (HRef of the folder sent items)
  • CALENDAR
    (HRef of the folder calendar)
  • CONTACTS
    (HRef of the folder contacts)
  • TASKS
    (HRef of the folder tasks)
  • VERSION
    (Version of the Exchange server in the Exchange configuration)

The comparison value "Language" will filter the table entries depending on the language setting of the portal. A requirement of this is that all data fields that will be compared must have a language key (such as "de", "en") for every data record. The comparison value "Layout" will filter the table entries depending on the current layout of the portal.

Binding

You can compare the value of the date field with session values, request values, values from the processing context, system data fields or parameters. Values can only be compared with parameters in applications. Parameters cannot be selected as the comparison value in processes.

Default

Enter the name of the binding here.

User-defined

As user-defined, static comparison values, any character string can be entered to compare string data fields. Please note that casesensitivity will be considered here. Integer and float data fields can be compared with a number. Datetime data fields can be compared with a date.

Filter

This comparison value can be selected when either "Is contained in" or "Is not contained in"is defined as the operator.

Edit subquery

Opens a dialogwhere the subquery for a data group can be defined.