Database Function
Last updated
Last updated
This action will execute a standard query function on an active cursor.
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. |
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. |
Unique Values | Will return a model containing an array with all the unique values of the specified field. |
Function execution does not rewind the current cursor. Using this action on a cursor that already moved may lead to incorrect values.
This action does not have any trigger.
This action produces the following variables after being triggered:
Variable | Description |
database_function_result | The result of the function execution |
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. |
