Database Function
This action will execute a standard query function on an active cursor.
Settings
The action uses the following settings:
Setting | Description | |
Function | The function to be executed | |
Field | The name of the field to be used as parameter for the function, if required. | |
Separator | The text separator to be used when joining data |
Remarks
This action will execute one of three different functions using an active query cursor. After the function is executed, the cursor is closed.
Function | Result |
---|---|
Count | Will return the amount of elements returned by the query |
Sum | Will sum all values in the specified field. Any field value that cannot be translated to a number will be threated as a zero. |
Join | Will return a string with all the unique values that are found in the specified field for up to 256 records. Each entry will be separated using the string specified in the Separator value. Values longer than 1024 characters will not be joined. |
Function execution does not rewind the current cursor. Using this action on a cursor that already moved may lead to incorrect values.
Trigger
This action does not have any trigger.
Variables
This action produces the following variables after being triggered:
Variable | Description |
database_function_result | The result of the function execution |
Availability
Availability
Channel specific availability follows the table below:
Channel | Availability |
Fully Available. | |
Fully Available. | |
SMS | Fully Available. |
Telegram | Fully Available. |
Web | Fully Available. |
Alexa | Fully Available. |
Google Assistant | Fully Available. |
Slack | Fully Available. |
API | Fully Available. |
This action requires an active Database package. This action can only be used as an operation for a Save action.
Last updated