Identity Manager 9.2 - Web Designer Web Portal User Guide

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
Filter	Description
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 and select a date.
- Enter the date in the field.

Click Apply.

The filter is applied. The matching results are displayed in the view.

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
View	Description
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
Value type	operator	Description
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.

Identity Manager 9.2 - Web Designer Web Portal User Guide

Filtering the calendar function

Delete filter

Custom filter conditions

Detailed information about this topic

Creating filters using the wizard

请选择您的产品：

为向您提供更好的服务，请填写'Purpose of your Chat'（联系目的）：

针对您的问题建议的解决方案

Identity Manager 9.2 - Web Designer Web Portal User Guide

Filtering the calendar function

Delete filter

Custom filter conditions

Detailed information about this topic

Creating filters using the wizard