Database Function

This action will execute a standard query function on an active cursor.

Settings

The action uses the following settings:

Setting	Description	Parsed
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
Facebook	Fully Available.
WhatsApp	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.