Customer(s)

General Electric

Description

Automatic reporting via our SQL feature used to generate a file with a hard-coded name. Now the file name is configurable. In other words, we added new property to SQL Report action config to set template to generate attachment name. If this is left empty, attachment will be set to action name (existing behavior).

Within the template you have access to the action config and result set, as well as built-ins from freemarker.

Example:

Report ${config.name} - ${.now?string[\"dd_MMM_yyyy\"]} - ${result.rowCount} rows
CODE

Results in:

MyReport - 04_MAY_2020 - 1384 rows.csv
CODE