QUERY SCRATCHPADENTRY (Query a scratch pad entry)

Use this command to display data that is contained in the scratch pad.

Privilege class

Any administrator can issue this command.

Syntax

Read syntax diagramSkip visual syntax diagram Query SCRATCHPadentry ***major_category**minor_category*subjectLine=*Line=number

Parameters

major_category
Specifies the major category to be queried. This parameter is case sensitive. You can query all major categories by omitting this parameter.
minor_category
Specifies the minor category to be queried. This parameter is case sensitive. You can query all minor categories in the major category by omitting this parameter.
subject
Specifies the subject to be queried. This parameter is case sensitive. You can query all subjects in the minor category by omitting this parameter.
Line
Specifies the number of the line to be queried. For number, enter an integer in the range 1 - 1000. You can query all lines of data in the subject by omitting this parameter.

Example: Query scratch pad entries

Query a database that stores information about the location of all administrators.
query scratchpadentry admin_info location
Scratchpad major category: admin_info
     Scratchpad minor category: location
            Scratchpad subject: codjo
        Scratchpad line number: 1
               Scratchpad data: Toronto 5A24
         Date/time of creation: 2013-09-10, 10:15:50
         Last Update Date/Time: 2013-09-10, 10:15:50
Last Update by (administrator): CODJO

     Scratchpad major category: admin_info
     Scratchpad minor category: location
            Scratchpad subject: jane
        Scratchpad line number: 1
               Scratchpad data: Raleigh GF85
         Date/time of creation: 2013-09-09, 14:29:40
         Last Update Date/Time: 2013-09-09, 14:29:40
Last Update by (administrator): JANE_W

     Scratchpad major category: admin_info
     Scratchpad minor category: location
            Scratchpad subject: jane
        Scratchpad line number: 2
               Scratchpad data: Out of the office from 1-15 Nov.
         Date/time of creation: 2013-09-09, 14:30:05
         Last Update Date/Time: 2013-10-31, 16:55:52
Last Update by (administrator): JANE_W

     Scratchpad major category: admin_info
     Scratchpad minor category: location
            Scratchpad subject: montse
        Scratchpad line number: 1
               Scratchpad data: Barcelona B19
         Date/time of creation: 2013-09-10, 04:34:37
         Last Update Date/Time: 2013-09-10, 04:34:37
Last Update by (administrator): MONTSERRAT


Field descriptions

Scratchpad data
The data that is stored in the scratch pad entry.
Date/time of creation
The date and time at which the scratch pad entry was created.
Last Update Date/Time
The date and time at which the scratch pad entry was last updated.
Last Update by (administrator)
The administrator who last updated the scratch pad entry.

Related commands

Table 1. Commands related to QUERY SCRATCHPADENTRY
Command Description
DEFINE SCRATCHPADENTRY Creates a line of data in the scratch pad.
DELETE SCRATCHPADENTRY Deletes a line of data from the scratch pad.
SET SCRATCHPADRETENTION Specifies the amount of time for which scratch pad entries are retained.
UPDATE SCRATCHPADENTRY Updates data on a line in the scratch pad.