Select the “Specify Filters” link in the “Define View” page.
The “Specify Filters” 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 access type of the view, which could be either “Public” or “Private”. |
|
Date Format |
The format in which the date fields are displayed. The system supports the “DD MMM YYYY” format. |
|
Time Format |
The format in which the time fields are displayed. The system supports the “HH:MM:SS” format. |
Enter the following fields in the “Filter 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 column name, 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 value used for filtering the records in the view output (Alphanumeric, 1000). The data type of the value entered depends on the column data type. |
A Values should be specified in the “Value” field for filter conditions, other than “Between”, “Not Between”, “ Any Of” and “Not in Any Of”, specified in the “Filter” field.
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” the result must be retrieved even when one of the conditions is satisfied. |
Click the “Save” pushbutton to store the filter conditions for the view.
Select the “Specify Enumerated Values” link to specify enumerated values for the data.
Note: Ensure that “Column Alias” and “Filter” values are specified in the multiline. Also ensure that at least one record is selected in the multiline. Enumerated values can be specified only if the “Filter” is “Between”, “Not Between”, “Any Of” or “Not in Any of”.
