===== createProcessInstancesByQuery =====

==== Description ====

This timer starts a process instance using a query. For every row in the table a new instance is started and for every column a [[:en:software:tim:process_variables|process variable]] with the column name as the name is saved in every instance.

----

==== class ====

<code>
com.dooris.bpm.actionhandler.CreateProcessInstancesByQuery
</code>

----

==== Event Type ====

any

==== Webservice Name ====

<code>
ProcessInstanceManager
</code>

==== Webservice Method ====

<code>
createProcessInstancesByHandler
</code>

----

==== Parameter ====

In the parameter field the first thing is the actionhandler class, seperated with a comma, followed by the rest of the parameters. These are seperated with a #.

== processdefinition ==

This parameter determines the process definition an instance should be started of.

== connectionParameter ==

With this parameter the data for the database connection is transferred in the sequence of connection path, user and password. These are seperated with a +.

== sqlFile ==

This determines the path to the SQQ file, which should be used for starting the instance.

== limit ==

This parameter determines the maximum number of instances that can be started within a single passing of this timer. If nothing is transferred here, thre limit is loaded from the [[:en:software:tim:tim.properties|]]. The default is 5.

----

==== example ====

{{  :software:tim:actionhandler:createprocessinstancebyquery.png?direct&712x614  }}

----

==== dependencies ====

__Timer__: [[:software:tim:timer:createprocessinstancesbyhandler|createProcessInstancesByHandler]]