Database Task
The Database Task element reads or writes data that Cellosign stores for business processes, BPMN processes, forms and transactions, and then the process continues. Use it, for example, to count the open requests of a client or to save a value for later processes. It’s available when customer data is included in your organization’s plan.
To add one, drag Database Task from the palette. Its settings are on these tabs:
- General: the ID and the Name shown on the canvas (default: “Database”).
- Inputs: the data the task uses. See Inputs and data.
- Database: what to read or write.
- Outputs: the data that was read.
- Multi Instance: shown only for a multi-instance element. See Repeat an element for each item.
Database settings
Section titled “Database settings”| Setting | What to enter |
|---|---|
| Instance | Always $builtin, the Cellosign database. |
| Relation | The kind of record: Business Process, Form, BPMN Process or Transaction. Required. |
| Action | What to do. See the table below. Required. Select the action even for a new task. |
| Action | What it does | Output |
|---|---|---|
| Count | Counts the records that match the conditions. | count (number) |
| Select | Reads all the records that match. | entries (list) |
| Select First | Reads the first record that matches. | object (dict) |
| Select Last | Reads the last record that matches. | object (dict) |
| Update | Changes the values in the records that match. | – |
| Create | Creates a record. | – |
| Delete | Deletes the records that match. | – |
| Attach | Attaches files to the records that match. | – |
Conditions
Section titled “Conditions”Shown for all actions except Create. Conditions choose the records to work on. Click + Add Condition for each condition:
- Column: the name of the column.
- Operator: Equal, Not Equal, In or Not In.
- Value: the value to compare with, or turn on the switch to use a Reference to an input or an output of an earlier element.
Inputs
Section titled “Inputs”Shown for Create, Update and Attach. The values to write. Click + Add Input for each column, and enter the Column and the Value or a Reference.
Outputs
Section titled “Outputs”The output depends on the action, as shown in the table above. Later elements can use it, for example in an exclusive gateway condition such as “count greater than 0”.
Validation
Section titled “Validation”The editor reports a condition or an input without a column or a value under Validation Errors.