Setting up a table and corresponding query
The FSWFLOG table contains the predefined parameters that
are automatically populated if LogAddRec is called in a
script using the RESULT query. In addition to the
predefined parameters, the table has columns for user-defined custom values.
The query is added to the FSQUERY table
as WLOGQueryNameADD in the QUERY_CODE column. QueryName is the custom query name. RESULT is
the pre-established QueryName to use the FSWFLOG table.
Optiva predefined parameters
The predefined parameters, were added to the FSWFLOG
table, using the WLOGRESULTADD query.
| Predefined Parameter | Information That Is Inserted |
|---|---|
| LOG_ID | A sequential identification number that is assigned to the log. |
| ACTIONWIP_ID | The Work ID |
| LINE_ID | The line number of the task |
| ACTIONSET_CODE | The Action Set code |
| ACTION_CODE | The Action code |
| ASSIGNED_USER_CODE | The user that is assigned to the task
that contains LogAddRec. |
| SOURCE_USER_CODE | The user who started the workflow |
| C_CUSTOM1 | Extension field one |
| C_CUSTOM2 | Extension field two |
Examples
In this example, the function searches the
FSQUERY table for the
WLOGRESULTADD QUERY_CODE. The entry refers the system
to the appropriate table and fills in the information.
Inserts log ID and predefined parameters into log table. No custom parameters are defined.
Dim lLog As Long = LogAddRec("Result",0)
Inserts log ID, predefined parameters, and custom parameters into the
log table. The
text and
5555, local variables in this event are custom
parameters.
Dim lLog As Long = LogAddRec("Result",0,text,5555)
Inserts log ID and custom parameters into the log table.
Dim lLog As Long = LogAddRec("Result",1,text,5555)
Inserts custom parameters into the log table.
Dim lLog As Long = LogAddRec("Result",2,text,5555)