This command returns a count of the number of work items in a specified queue or roster in the current isolated region.
Syntax
count <queue_or_roster_name> [<filter_clause>]
Parameters
queue_or_roster_name |
Name of queue or roster. Enter an asterisk (*) to count all work items in all queues and in all rosters. The total roster and queue entries display at the end. Enter a pound sign (#) to count all work items in all queues and in all rosters for which the count is non-zero. The total roster and queue entries display at the end. 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). |
filter_clause |
SQL WHERE clause to use for query. This parameter is optional; if you include it, vwtool returns the number of records satisfying the expression. If you do not specify a filter clause, vwtool returns the number of records in the specified queue or work class. For details on the syntax for your query, see the documentation for the SQL database server to which you're sending the query. |