Basic information
Package: com.suncode.plugin.scheduldedtask.task.AcceptActivityWithDBexplorer
Available from version: 1.0.14
Description
Task searches for selected open tasks from a given user. Then it executes a prepared query for each task (it can execute a query with parameters taken from the process). When the query returns any results, the task will be accepted (it also allows saving the downloaded data to the task before accepting it).
Configuration parameters
Id of the variables from the process
| Parameter name | from version | Description | The type of the parameter | Notes and Restrictions | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Database | 1.0.14 | Connection name to database from Data Editor configuration | String | |||||||||
| Query name | 1.0.14 | Name of the query from the pm_dbqueries table (query_name) | String | |||||||||
| userName | 1.0.14 | The login of the user for which the tasks will be searched. | String | |||||||||
| processDefId | 1.0.14 | Process definition ID | String | |||||||||
| activityDefId | 1.0.14 | Activity definition ID | String | |||||||||
| Action name | 1.0.14 | The name of the action (button) to be performed when accepting the task. | String | Setting the value to blank causes the default accept button (when none is present on the form). | ||||||||
| Id of the variables from the process | 1.0.14 | A list of variable identifiers (separated by a comma) from the process that will be used to execute the query. The order matters. | String | Possibility to use process array variables | ||||||||
| Save the received data in the processed activity | 1.0.14 | Updates the activity context with the data retrieved from the database. Return column names must match the process variable identifiers. | Boolean | You can use aliases on the returned columns in your query | ||||||||
| Multiple value support for a header variable | 1.0.14 | Possible types BLOCK, FIRST, UNIQUE | Boolean | Used when updating header variables in the process
| ||||||||
| Overwriting tabular variables | 1.0.14 | When 'true', the retrieved tabular variables will be replaced, otherwise the new values will be added. | Boolean | Used when updating tabular variables in the process |
Sample configuration
Sample task configuration:
Sample query:
Change log
1.0.14 (applicable documentation)
- Create a scheduled task