====== ProcessVariablesToTableHandler ======
==== Description ====
This handler allows process variables to be stored in a special table. It is also possible to save the names of all attached documents in this table. The table takes on 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 contents of the variables are saved. 
  * If documentList is true, as additional column exists at the end of the table. There, the names of all attached documents are stored.

------
==== Action Class ====
<code>
com.dooris.bpm.actionhandler.ProcessVariablesToTableHandler
</code>
\\
----
==== Event Type ==== 
any
==== Action Name ==== 
any
==== Mandatory Fields ==== 
none
----
==== Parameter ==== 
== jdbcURL==

Here the URL of the desired databank + schema is given. 
Explanation: see [[#Example]]

\\ == userName ==
Here the username used to log in to the databank is entered. 
Explanation: see [[#Example]]

\\ == password ==
Here, the correct password for the given user must be entered. 
Explanation: see [[#Example]] 

\\ == tableName==
Here, the name of the table in which the variables are saved is given. 
Explanation: see [[#Example]] 


\\ == processVariables==
Here the names of the variables being stored in the databank table are given. These must be separated by a comma (",").
Explanation: see [[#Example]] 

\\ == documentList==
Here, an indicator (true / false) stating whether the databank should also store the names of all documents is given. 
Explanation: see [[#Example]] 

>> **Caution!** At this point, it is important to note is an additional column is created for the documents.

----

==== Example ====

{{ software:tim:actionhandler:db_table.png }}
{{ software:tim:actionhandler:processvariablestotablehandler.png }}
----