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.