ProcessVariablesToTableHandler

Description

This handler allows process variables to be stored in a separate table. It is also possible to save the names of all the attached documents in this table. The table must have the following structure:

A column ID, with characteristics PrimaryKey and UniqueIndex in the first column. The ID of the process instance is saved here.
One column per process variable. Here, the content of the variables is saved.
If the documentList parameter is true, an additional column exists at the end of the table. There, the names of all the attached documents are stored.

Class

com.dooris.bpm.actionhandler.ProcessVariablesToTableHandler

Parameter

Parameter name	Default value	Description	Valid examples

Parameter name	Description	Valid examples
`jdbcURL`	Here, the URL of the desired database and schema is given.	`jdbc:mysql://localhost:8080/system`
`userName`	Here, the username used to log in to the database is entered.	`root`
`password`	Here, the correct password for the given user must be entered.	`passwort`
`tableName`	Here, the name of the table in which the variables are saved is given.	`Processvariables`
`processVariables`	Here the names of the variables being stored in the database table are given. These must be separated by a comma (“,”).	`variable_1,variable_2,variable_3`
`documentList`	Here, an indicator (true/false) stating whether the database should also store the names of all documents is given. It must now be noted that an additional column for the documents is created at the end of the database table.	`true`