CreateProcessInstancesByQuery

Owned by Betül Kara (Deactivated)
Last updated: Jul 16, 2024 by Daniel Mederl
2 min read

Description

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

Class

com.dooris.bpm.actionhandler.CreateProcessInstancesByQuery

Parameter

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

Parameter name

Default value

Description

Valid examples

Parameter name

Default value

Description

Valid examples

processdefinition

 

This parameter determines the process definition of which one or many instances should be started.

Onboarding

connectionParameter

 

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)

Label

Value (Example)

Timer name

Create Process Improvement Flow

Webservice name Mandatory

ProcessInstanceManager

Webservice method 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 Mandatory

5

Dependencies

Timer: CreateProcessInstancesByHandler

© TIM Solutions GmbH | AGB | Datenschutz | Impressum