Filtering the calendar function
The "Calendar function" filter is, for example, available in the Request date column of the Request History view.
To apply filter criteria to the calendar function
-
Select one of the following criteria in the context menu next to the field.
Table 9: Other criteria for applying filters to the calendar function
|
After |
Only displays results after this date. |
|
Before |
Only displays results before this date. |
|
Between |
Only displays results between these dates. Another field with calendar icons is displayed with this setting. |
|
This week |
Only displays results with this week's date. |
|
Last week |
Only displays results with last week's date. |
|
This month |
Only displays results with this month's date. |
|
This year |
Only displays results with this year's date. |
-
Perform one of the following tasks:
-
Click Apply.
The filter is applied. The matching results are displayed in the view.
Delete filter
After setting a filter, you can remove it again manually or it is removed automatically when you change views.
To delete a filter
Custom filter conditions
In some places in the Web Portal you can create custom filter conditions. The filter conditions are formulated like a condition (WHERE clause) for a database query.
You can use a wizard to formulate the queries. Each condition is displayed in a special control in the wizard.
The wizard is available to you at different places in the Web Portal.
To open the filter wizard
Detailed information about this topic
Creating filters using the wizard
To create a filter with the wizard, first select a column, edit the conditions and comparison operators. Once these settings have been configured, you can apply the filter.
To create and apply a filter with the wizard
-
Click View settings > Open filter wizard.
-
Select the column for the table in the filter wizard.
-
Click At least one entry exists and specify whether the column should reference or be referenced from other tables.
The following views are available.
Table 10: Views in the filter wizard
|
Value comparison |
Compares the values of the selected columns.
These columns are part of the table you want to apply the custom filter to.
The advantage of using the WHERE clause wizard is that you can select all the table's columns as opposed to the filter function, which only provides a default selection of columns. |
|
References to other objects |
Creates a n:1 relation.
Select the desired table B in this view. Several data records from table A can be assigned to one data record in table B. A data record in table A cannot be assigned more than one data record from table B. |
|
References for assignment tables |
Creates a 1:n relation.
Each data record in table A can be assigned to several data records from table B and vice versa. These relations are realized through a third Table for realizing assignment tables Assignment table only contains the foreign keys of the other tables A and B. |
|
References from other objects |
Creates a 1:n relation.
Select the desired table B in this view. Several data records from table B can be assigned to one data record in table A. A data record from table B cannot be assigned to more than one data record from table A. |
-
Select the desired column in the Filter wizard view.
This inserts a control for the first condition.
Figure 1: Filter wizard with example conditions
-
Enter the condition and configure the following settings:
-
Enter the comparison value.
You can enter a date, numeric, or text value. The input of the value type depends on the selected column.
-
Change the comparison operator.
To change the comparison operator, click the comparison operator "is less than", for example.
The type of comparison operator depends on the column type. The following comparison operators are available.
Table 11: Comparison operators
|
Text value |
is equal to |
Finds the same text value. |
|
Precedes the word in the alphabet |
Finds all results that occur before the entered text in alphabetical order. |
|
Follows the word in the alphabet |
Finds all results that occur after the entered text in alphabetical order. |
|
Not equal |
Finds all results that are not the same as the entered text. |
|
Is contained in |
Finds all results that contain the text value. |
|
Contains |
Finds all results that contain the text value. |
|
Begins with |
Finds all results that begin with the entered text value. |
|
Ends with |
Finds all results that end with the entered text value. |
|
Is equal or precedes the word in the alphabet |
Finds all results that either contain the entered text value or occur before the entered text value in alphabetical order. |
|
Is equal or follows the word in the alphabet |
Finds all results that either contain the entered text value or occur after the entered text value in alphabetical order. |
|
Numerical value |
Is less than |
Finds all results that are smaller than the entered numerical value. |
|
Is greater than |
Finds all results that are larger than the entered numerical value. |
|
is equal to |
Finds all results that are the same as the entered numerical value. |
|
Is less or equal |
Finds all results that are less than or equal to the entered numerical value. |
|
Is greater than or equal |
Finds all results that are greater than or equal to the entered numerical value. |
|
Not equal |
Finds all results that are not the same as the entered numerical value. |
-
Change the Boolean value if the option is available in the selected column.
The value false is selected by default. If you change the value to true, data appears that matches the content of this column.
-
To negate the defined condition, click applies.
The condition statement is reversed and the data displayed after filtering, does not match this condition. This setting is not available if the Boolean option can be set.
-
Use the operators and or or when applying multiple conditions.
NOTE: Remove the control by clicking 
.
-
Insert another expression with <<Add expression>> and repeat this step if required.
-
Perform one of the following tasks:
-
Apply the filter by clicking Apply.
This returns you to the original view where a message alerts you to the active filter wizard.
-
Close the wizard with Close.
and select a date.