FireCall Log Advanced Sort & Search screen
How to Get There
- From the FireCall Menu, select option 2 (FireCall Log).
- From the Work with FireCall Log screen, select option F14 (Sort & Search) .
- From the FireCall Log Basic Sort & Search screen, select option F11 (Advanced Search) .
What it Does
This feature provides the capability to order advanced sort and search results. (The sort and search function builds an SQL statement based upon the selections made.)
Options
Sort Order
Provides the capability to order the search results. Possible values are 1 through 6 where 1 is highest and 6 is lowest. If an item is left blank it will not to be used when sorting the search results.
- FC Operator – The IBM name of the user profile that enabled the profile switch to occur.
- System User – The IBM name of the user profile that performed the profile switch.
- Switch Profile – The name of the IBM user profile the system user switched to.
- Date – The calendar date the system user was authorized to perform the FireCall switch.
- From Time – The time the FireCall switch was authorized to perform the FireCall switch. Military time is used.
- Call Ticket – The call ticket is the user-supplied reference number to the FireCall access. It can be any combination of letters and numbers (up to 20 characters) that corresponds to a ticket number from a help desk system such as Remedy.
Search Criteria
FireCall Operator selections: Select the FireCall Operator you wish to see. Leave FireCall Operator blank if you wish to see all FireCall Operators. SQL WHERE CLAUSE syntax is used to make FireCall Operator selections.
Sample entries for FireCall Operator:
= 'HELPDESK1'
IN ('HELPDESK1', 'HELPDESK2', 'SECURITY1')
LIKE(U%)
BETWEEN 'HELPDESK1' AND 'SECURITY1'
Wild card character '%' is supported. For example, an system user entry of AR% will list only system users from AR through AR99999999.
The entry will be all upper case.
System User selections: Select the System User you wish to see FireCall Logs for. Leave System User blank if you wish to see all System Users. SQL WHERE CLAUSE syntax is used to make System User selections.
Sample entries for System User:
= 'USER1'
IN ('USER1', 'USER2', 'USER3')
LIKE('R%')
BETWEEN 'USERA' AND 'USERR'
- Wild card character '%' is supported.
- The entry will be all upper case.
Switch Profile selections: Select the Switch Profile you wish to see FireCall Logs for. Leave Switch Profile name blank to see all Switch Profiles. SQL WHERE CLAUSE syntax is used to make Switch Profile selections.
Sample entries for Switch Profile:
= 'PRF1'
IN ('PRF1', 'PRF2', 'PRF3')
LIKE('R%')
BETWEEN 'PRFA' AND 'PRFR'
- Wild card character '%' is supported.
- The entry will be all upper case.
Assignment Date selections: Select the Assignment Date you wish to see FireCall Logs for. Leave Assignment Date blank to see all Assignment Dates. SQL WHERE CLAUSE syntax is used to make Assignment Date selections. Dates must be entered in ISO format YYYY-MM-DD.
Sample entries for Assignment Date:
= '2005-04-28'
IN ('2005-04-28', '2005-05-28', '2005-06-28')
LIKE('2005%')
BETWEEN '2005-04-28' AND '2005-05-28'
Wild card character '%' is supported.
Assignment Time selections: Select the Assignment Time you wish to see FireCall Logs for. Times must be entered in format 'HH.MM' or 'HH.MM.SS'. Leave Assignment Time blank to see all Assignment Times. Use SQL WHERE CLAUSE syntax to make Assignment Time selections.
Sample entries for Assignment Time:
= '12.35'
IN ('12.35', '13.33', '18.21')
LIKE('12%')
BETWEEN '01.01.00' AND '24.00'
Wild card character '%' is supported.
Call Ticket selections: Select the Call Ticket you wish to see FireCall Logs for. Leave Call Ticket blank to see all Call Tickets. SQL WHERE CLAUSE syntax is used to make Call Ticket selections.
Sample entries for Call Ticket:
= 'HC1211'
IN ('PMR3345', 'HC3341')
LIKE('PMR%')
BETWEEN 'HC3341' AND 'HC5522'
- Wild card character '%' is supported.
- The entry will be case insensitive (UCASE() used when building the WHERE).
Command Keys
F3 (Exit): Ends the current task and returns to the display from which the task was started. If changes have not been accepted prior to F3 being pressed they will be lost.
F5 (Refresh): Restores the display to the values found in the database. Any changes will be lost.
F12 (Cancel): Returns to the previous menu or display. If changes have not been accepted prior to F12 being pressed they will be lost.