JavaScript is disabled on your browser.

Filter Definitions

For various elements, such as tables and selection lists, filters may be set up. 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.

A filter expression consists of three parts: 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.

The data field will be defined in the Data field selection list. All data fields of the current application, including reference fields, can be chosen. The Operation selection list allows you to choose the operator. The Comparison value will be defined in the lower area of the dialog. The completed filter expression will be entered to the filter list when you click on OK.

Operators

In the Operation selection list, depending on the type of data field of the selected data field, various operators are available.

Data Type string, longtext

Operator Delivers
Equal Identical string (case sensitive)
Unequal All non-identical strings
Smaller than, or equal Strings with smaller or equal number of character values (ASCII)
Smaller than Strings with smaller number character values (ASCII)
Exceeding or equal Strings with exceeding or equal number of character values (ASCII)
Exceeding Strings with exceeding number of character values (ASCII)
Undefined Field does not contain any valid data or has not been initialized
Defined Fields with any number of entries (also empty fields when saving a page without an entry)
Contains Field contains string of reference value
Starting with Strings with initial characters equalling the reference value
Ending with Strings with last character equalling the reference value

The operators Less than or equal, Less than, Greater than or equal, 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.

For the operators Contains, Begins with, and Ends with, the setting for Negation can be selected. This will filter all data records for those in which the set condition does not apply. When one creates, for example, a filter expression for the User Manager that checks whether the name Meier is contained in the Full name data field, all users with the last name of Meier will be identified. With the Negation setting, all users will be identified in which the name Meier is not contained.

Data Type integer, float, datetime

Operator Delivers
Equal Equal values
Unequal Unequal values
Smaller than, or equal Smaller or equal values
Smaller than Smaller values
Exceeding, or equal Exceeding or equal values
Exceeding Exceeding values
Undefined Field does not contain valid data or has not been initialized
Defined Fields containing entries
is included in See hint below

The operator Is contained in will deliver, for example, the manager of a user. The filter will be set up for the system field PK (S) LID from the application Users in this case, which returns all user IDs. The operator Is contained in will compare the user IDs in the list to the Superior ID contained within the data of the current user.

Operator Delivers
Equal Equal logical value
Undefined Fields with the value NULL
Defined Fields with either the value True or False

Comparison Value

Data Field

In the Data field selection list, 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. The selection list will automatically only show fields where this is possible.

Current Value

With this comparison value, a filter can be placed on a page that shows a single data record, which will show all additional data records of the data group that contain the current value of the selected data field. The filter can, for example, be used to show all keys that have been given to an employee. For this to occur, a way of identifying the employee (such as a personnel number) must be saved within every data record of the data group. For the comparison with the current values, you can only select data fields, which are linked to a control on the same page. The same value must therefore be shown, for example, in an edit or view element on the page.

Current User

Integer data fields will compare the UserID of the current user to another value. This comparison value can be used to show data records that have been created by the currently logged on user. The comparison value Superior IDs and the operator Is contained in return a list of the Superior IDs of the current user. The comparison value Alternate ID returns the ID of the assistant of the current user. A string data field can set the filter up for data fields of the Users application.

System Value

The selected data field will be compared here with the Data set ID of the currently displayed data set. The comparison value Parent data set ID runs the comparison against the ID of the super-ordinate data record. A comparison with a Request value can be entered in the Value field with the name of the request parameter and in Preset a default value, which will be used for null values. Session Variable will compare in the same way with the value of a session variable.

With Processing Context you have the ability to compare the values of variables from the processing context. Enter the name of the variable in the field Value. Default Value will be used when the variable is not defined.

With Superior ID you have the ability to ascertain users that are assigned to a superior.

The comparison values Set and Container, combined with the operator Is contained in, return data records of users that are contained in the set or container that you can choose from the selection list below the comparison value.

If the selected data field is a Datetime data field, the value of that field can be compared with the current date. As with edit fields, here you have the ability to dynamically adjust the date.

With the Date Adjustment, date values can be dynamically increased or decreased in relation to the current date. The following values are allowed, whereby X corresponds to an arbitrary integer:

Year -X removes X years from the current date; +X adds X years to the current date.

Month -X removes X months from the current date; +X adds X months to the current date. If X is not a valid month (example: 34), the month will be set to 12.

Day -X removes X days from the current date; +X adds X days to the current date.

If the day has the value 1, the first day of the month will be entered. If the day is set to 0, the last day of the previous month will be used. If the month has the value +1 and the day has the value 0 the last day of the current month will be used. Hours, minutes, and seconds can likewise be adjusted in regard to the current time, as long as the control type Date And Time or Time is used.

If all data records within a specific time frame should be returned, a filter must be defined with an AND link. So, for example, the filter expression to deliver all appointments for the current day should read as follows:

AppointmentStart < Systemvalue today (with time)
Date adjustment: Day + 1, Hour 0, Minute 0, Second 0
AND
AppointmentEnd > Systemvalue today (with time)
Date adjustment: Hour 0, Minute 0, Second 0

String or text data fields can be compared with the system value exchange mailbox info. The following values are available: 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.

User Defined

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