Advanced Reporting Exceptions Sort & Search screen
How to Get There
On the Basic Reporting Exceptions Sort & Search screen, press F11.
What it Does
The Reporting Exceptions Sort and Search feature is used to filter and sort the entries shown in the Reporting Exceptions screen.
Several options are available to filter and/or reorder the entries that are listed. The first of these options is the ability to sort the entries in the list by the values in one or more fields. Second, you can filter the information by specifying that you only want to see entries with specific values in certain fields. Lastly, you have the option of defining more advanced selection criteria using SQL syntax.
Options
Sort Order
The sorting sequence section provides the capability to order your results by the values in one or more fields. Possible values are 1 through 5 where 1 is highest and 5 is lowest. If left blank, the results are left in their original order.
Object name: Enter a value of 1 through 5 to specify the order of sorting for the Object Name field. If left blank, it is not used when sorting filter results.
Library name: Enter a value of 1 through 5 to specify the order of sorting for the Library Name field. If left blank, it is not used when sorting filter results.
Object type: Enter a value of 1 through 5 to specify the order of sorting for the Object Type field. If left blank, it is not used when sorting filter results.
User profile: Enter a value of 1 through 5 to specify the order of sorting for the User Profile field. If left blank, it is not used when sorting filter results.
Filter: Enter a value of 1 through 5 to specify the order of sorting for the User Profile field. If left blank, it is not used when sorting filter results.
Search Criteria
The Search Criteria section provides the capability to filter the entries in the Reporting Exceptions list based on the values in certain fields. Fields available for filtering are Filter, Object name, Library name, Object Type, and User Profile selections.
All fields, with the exception of the Filter field, can be filtered using generic values. The generic indicator is the % symbol. So, for example, the list of entries can be restricted to just those objects that start with the letters PAM by specifying PAM% in the object name field.
Filter selections: Active, Inactive
Use X to select to view just one filter or the other. If you wish to see entries that are both Active and Inactive, then leave both fields blank.
Object name, Library name, Object type, User profile selections:
Enter the object name/library name/object type/user profile that you wish to see in the Reporting Exceptions list. Leave the field blank if you wish to see all objects. You can also specify more advanced SQL syntax for selection by using sql terms like IN and BETWEEN to further limit your selection.
Command Keys
Enter (Accept): Press Enter twice to accept your entries. Otherwise, press F12 to cancel.
F3 (Exit): Exit the program without processing any pending changes.
F5 (Refresh):Clear the entries and start over.
F12 (Previous): Cancel processing for the current display and go back to the previous display.