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

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

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

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

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

The editor reports a condition or an input without a column or a value under Validation Errors.