Page Comparison

...

This timer starts a process instance using a query. For every each row in within the table, a new instance is started and for every each column, a process variable with a process variable with the column name as the name is saved stored in every instance.

...

Class

Code Block
com.dooris.bpm.actionhandler.CreateProcessInstancesByQuery

...

In the parameter field, the ActionHandler class must be specified first thing is the ActionHandler class, separated with which is separated by a comma (, followed by the rest of the ) from the remaining parameters. These The remaining parameters are separated with by a hashtag (#).

Parameter name	Default value	Description	Valid examples
`processdefinition`		This parameter determines the process definition

an instance

of which one or many instances should be started

of

.	`Onboarding`
`connectionParameter`

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

This parameter specifies the connection to the SQL Server (Database).
It consists of the following 3 parts

Connection URL (includes host, port and name of DB schema)
Username
Password

and is separated by a plus (+).

jdbc:sqlserver://localhost:1433;databaseName=test+db_user+qwerty!1234

sqlFile

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

The file must be placed in the Resource folder.
Should it be placed in the ROOT folder it's enough to specify the file name & extension.
Otherwise, a path may be specified.

Example (ROOT-folder):
query.sql

Example (Sub-folder):
subfolder/query.sql

limit

5

This parameter determines the maximum number of instances that can be started within a single passing of this timer. If nothing is transferred here, the limit is loaded from the CreateProcessInstancesByHandler.

10

Example

...

Label
Value (Example)
Timer name
Create Process Improvement Flow
Webservice name
Status
colour Red
title Mandatory
`ProcessInstanceManager`
Webservice method
Status
colour Red
title Mandatory
`createProcessInstancesByHandler`
Parameter
`HANDLER_CLASSPATH,PROCESS_DEFINITION#CONNECTION_PARAMETER#SQL_FILE#LIMIT`
`com.dooris.bpm.actionhandler.CreateProcessInstancesByQuery,MY_WORKFLOW#jdbc:sqlserver://HOST:PORT;databaseName=DB_SCHEMA+USERNAME+PASSWORD#SQL_FILE#LIMIT`
Time to start
`1s`
Starting time
`17/07/2024 12:44`
Interval
`1`
Max. runs
Status
colour Red
title Mandatory
`5`

Dependencies

Timer: CreateProcessInstancesByHandler

Versions Compared

Old Version 3

New Version Current

Key

Class

`processdefinition`

`connectionParameter`

sqlFile

limit

Example

Dependencies