This page allows you to define the horizontal partitions. You can define a filter and associate it with any role. When a view is created, the mapped role would get only relevant information from the view. In other words, the roles mapped to the filter criteria would always get filtered information in the views.
Select the “Define Horizontal Partitions” link in the “Define Views” page.
The “Define Horizontal Partitions” page appears.
The system displays the following fields:
|
View Display Name |
The name of the view, as it appears in the “Inquiries” activity. |
|
View Type |
The type of the view, which could be “Adhoc”, “Audit” or “Report. |
|
View Access |
The view access, which could be “Public” or “Private”. |
|
Date Format |
The format in which the date fields are displayed in this page. The system supports the “DD MMM YYYY” format. |
|
Time Format |
The format in which the time fields are displayed in this page. The system supports the “HH:MM:SS” format. |
The system displays the current record and the total number of records available for the view.
Click the “Prev” pushbutton to move to the previous record.
Click the “Next” pushbutton to move to the next record.
A When there are no records specified for the view, a new record appears when the screen is invoked. If records are available, the last record appears when the screen is invoked. To add a new record, go to the last record and click “Next”.
Enter the following fields in the “Horizontal Partition Conditions” multiline:
|
Left Brace |
Use the drop-down list box to set the filter criteria using the left braces. The condition enclosed within the innermost braces would be executed first. |
|
Column Alias |
Use the drop-down list box to select the name of the alias column, required for the view. |
|
Filter |
Use the drop-down list box to select the filter criteria. The options include “Equal To”, “Smaller Than”, “Greater Than”, “Smaller Than or Equal To”, “Greater Than or Equal To”, “Between”, “Any Of”, “Starts With”, “Ends With”, “Contains”, “Blank”, “Null”, “Not Equal To”, “Not Between”, “Not in Any Of”, “Does not Start With”, “Does not End With”, “Does not Contain”, “Is not Blank” and “Is not Null”. |
|
Value |
The filter value for executing the view. The data type of the value entered depends on the column data type (Alphanumeric, 1000). Help facility available. |
The system displays the following field:
|
Enumerated Value |
The filter value defined for the view, when the filter is selected as “Between”, “Not Between”, “Any Of” or “Not in Any of”. |
Enter the following fields:
|
Right Brace |
Use the drop-down list box to set the filter criteria using the right braces. The condition enclosed within the innermost braces would be executed first. |
|
And/Or |
Use the drop-down list box to set the filter criteria as “And” or “Or”. Select “And” if both the conditions must be satisfied. Select “Or”, if the result must be retrieved even when one of the conditions is satisfied. |
Click the “Save” pushbutton to save the horizontal partition conditions.
Click the “Delete” pushbutton to delete the entered conditions.
Select the “Specify Enumerated Values” to specify the enumerated values.
Check one of the following boxes in the “Map To Roles” group box:
|
Map all Roles |
Check this box to map or associate the filter criteria to all users. |
|
Un-Map all Roles |
Check this box to un-map or dissociate the filter criteria from all users. |
Note: If any of the above two check boxes is checked, then the information in the “Map To Roles” multiline is ignored.
The system displays the following field in the “Map To Roles” multiline:
|
Role Name |
The name of the role mapped to the user. |
Enter the following field:
|
Map |
Check this box to map the user with the filter criteria specified. |
