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
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 locationScratchpad 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
| 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. |
