WFTRANSACTIONMSG - Database Reporting Guide - English - Foundation 22.1 - OnBase - external

Database Reporting Guide

Platform
OnBase
Product
Database Reporting Guide
Release
Foundation 22.1
License

A row is created in the WFTRANSACTIONMSG table under the following conditions:

  • The SYS – Custom Log Entry Workflow Action has been executed.
  • The Action, Task List, or Rule has the Log Execution check box selected, and the Action, Task List, or Rule is disabled.

The WFTRANSACTIONMSG table is located in DBSpace1.

WFTRANSACTIONMSG Table Values
Column Name Data Type Data Length Description
wftransactionnum bigint 8 Relates to wftransactionnum column in WFTRANSACTIONLOG table.
flags bigint 8 Not used, always zero.
wfmessage char 250 Dependent upon the objecttype in the WFTRANSACTIONLOG table (see comments below).

The index for the WFTRANSACTIONMSG table is located in DBSpace1.

WFTRANSACTIONMSG Table Index
Index Name Included Columns
wftransactionmsg1 wftransactionnum, flags

Comments

The value in the wfmessage column depends on the object type:

wfmessage column values
Object Type wfmessage Value
31 (SYS - Custom Log Entry action) The text specified in the action’s configuration.
32 (Action execute) If the action is disabled, the text reads: Action is disabled.
33 (Task list execute) If the task list is disabled, the text reads: Task list is disabled.
34 (Rule execute) If the rule is disabled, the text reads: Rule is disabled.