Batch processing actions
Use the Batch processing actions to run the SQL query and complete actions on the selected database records and, optionally, the corresponding batches.
The ProcessRunSqlQuery action runs the current query string
and generates a recordset that contains information about all matching
batches. For example, if you build a query by using QuerySetStatus("hold") and
your query locates one batch with status hold. The returned recordset
contains the following information that is aggregated from the tmbatch,
qstats, and queue tables.
<rs:data xmlns:rs="urn:schemas-microsoft-com:rowset"><z:row pb_adjustdocs="0"
pb_adjustpages="0" pb_batch="20100260.001"
pb_batchdir="C:\Datacap\APT\batches\20100260.001" pb_expectdocs="0" pb_expectpgs="8"
pb_headertable=" " pb_ndocs="0" pb_needMeet="0" pb_pagefile="rrsvscan.xml"
pb_pages="8" qs_elaps="8" qs_op="admin" qs_qid="3" qs_start="2010-09-17T07:35:26"
qs_station="2" qs_stop="2010-09-17T07:35:34" qs_taskid="VScan" qs_tsorder="0"
qu_admDB="156" qu_batch="20100260.001" qu_counter="0" qu_done="2010-09-17T07:35:34"
qu_elaps="8" qu_id="3" qu_job="Demo" qu_lock="none" qu_parent="0" qu_priority="5"
qu_spawntype="0" qu_start="2010-09-17T07:35:26" qu_status="hold" qu_task="VScan"
qu_tsorder="0" xmlns:z="#RowsetSchema" /></rs:data>The other actions in the batch processing category can manipulate the batches that are identified in the query results record set.