This command outputs the attributes of work items in a specified queue or roster in the current isolated region. Via the selective query option, you can use an index name to control the query and return the work items in ascending index order for the range of the index specified.
The wobquery command is useful for obtaining the work object number or queue name for use in subsequent vwtool commands. To easily use a work object number or queue name returned by wobquery in a subsequent command, use a terminal emulator program with cut and paste functionality.
You can optionally specify verbose output to output all of the fields of the selected record. If you don't select verbose output, wobquery prints out all data fields and a subset of the system fields for each record selected.
Syntax
The syntax varies depending on what you query.
To query | Syntax |
---|---|
a roster, without selective query |
wobquery <rostername> n <display> <size> <verbose> |
a roster, with selective query |
wobquery <rostername> {y <indexname> <minfieldval> <getvaluesequalmin> <maxfieldval> <getvaluesequalmin> <filter>} <display> <size> <verbose> |
a queue, without selective query |
wobquery <queuename> n <display> <size> <verbose> |
a queue, with selective query |
wobquery <queuename> {y <indexname> <minfieldval> <maxfieldval> <filter>} <display> <size> <verbose> |
Parameters
The parameters required depend on what you choose to query. Following is an alphabetical listing of all valid parameters for the wobquery command.
display |
Display work items, invocations, or queue or roster records. Enter "w" to display work items, "i" to display invocations, "r" to display roster records, or "q" to display queue records. |
filter |
This is a standard SQL WHERE clause using fields of the queue or roster. Either logical (user-defined) names or physical field names are allowed; pseudo field names are not allowed. (A pseudo field is a computed field held in memory, rather than an actual column in the database.) For details on the syntax for your query, see the documentation for the SQL database server to which you're sending the query. |
getvaluesequalmax |
Whether output should include records with values equal to maxfieldval. Enter "y" to include these records or "n" to exclude them. |
getvaluesequalmin |
Whether output should include records with values equal to minfieldval. Enter "y" to include these records or "n" to exclude them. |
indexname |
Index key name. In prompt mode, enter "?" to view a list of the available indices. |
maxfieldval |
The maximum value of the database field indicated by fieldname. The data type displays in datatype to help you determine the proper input. Depending on your answer, you might receive additional prompts for other minimum or maximum field values. |
minfieldval |
The minimum value of the database field indicated by fieldname. The data type displays in datatype to help you determine the proper input. Depending on your answer, you might receive additional prompts for other minimum or maximum field values. |
n |
No selective query specified. |
queuename |
Name of queue. If you specify a system or user queue, you must enter the queue name followed by "(0)". For example, to view information about the Delay system queue, enter Delay(0). |
rostername |
Name of roster. |
size | The object's approximate size in memory, and the number of objects it contains. |
verbose |
Output the selected records in verbose mode. Enter "y" to display all fields or "n" to display all data fields and a subset of the system fields. |
y |
Selective query specified. When using a selective query, you must specify an index key name to control the query. The work items display in ascending index order for the range of the index specified. |