GetItems
This method loads a set of macros to be evaluated from the Transaction Management tables. Selecting the category, date and user, this command will return a DataRecord containing the macros and their data. If a list of macros with a more complex selection criteria is desired use TM.GetItemsEx.
Group: Transaction Management
Syntax: [bOK = ] TM.GetItems(enStatus, vTranDate, sUserID, oTran)
bOK (Boolean) Optional – True or False for the success of the command
enStatus (enItemStatus) There are 4 options for the ItemStatus parameter:
tmAllItems all macros in all queues, in the queue, failed, or completed
tmCompleted all macros in all queues that were completed successfully
tmFailed all macros in all queues that were completed unsuccessfully
tmInProcess all macros in all queues that are not yet processed
vTranDate (Variant) specifies a single day to be retrieved
sUserID (String) specifies the user that performed the transaction
oTran (DataRecord) the variable declared as a DataRecord that contains the list of macros and their data. For more information on how the DataRecord object is used see the DataRecord section of the manual.
Example:
Dim bOK As Boolean
Dim oList As DataRecord
bOK = TM.GetItems(tmFailed, Date, "SAM", oList)
This command will return all the failed macros on the current day that was performed by the user Sam.