| Change type | Description |
|---|---|
| Introduced in version 13.1 | A new email notification feature has been added, allowing users to send output datastore data via email body, triggered by the completion of an Analysis stage in a process model. |
This Notify with Data Table Task is a configurable node in the workflow designer. It allows you to automatically send emails containing embedded data tables to selected recipients, making it easier to share process results and analysis outputs.
- After completing a data analysis run
- For regular or periodic reporting
- Select recipients
- Compose the email
- Choose the data source
- Apply filters
- Specify which columns to include
By automating notifications with relevant information, this task reduces manual work and helps ensure efficient communication.
Properties
The General tab
Display Name
Specify a name for the node.
Send to Group
Click the pencil button to select the environment group to which you want to send the notification.
Message
Type a subject for the email notification.
Message Details
Type the body of the email.
Output Variables
Optionally, define output variables to customize how the Process Model executes. For more information, see Process Model variables.
The Data Table tab
Source Data Store Name
Select the internal data store that contains the data you want to include in the email notification. Only internal default or database data stores are available for selection.
Data Load Range
- Based on Work ID Parameter (default): The system initializes the work ID parameter to use the output from the previous node (for example, the workId from an Analysis stage). If selected, add the Work ID Parameter Name set using the output variables in the General tab.
- All: Includes all records from the selected data store. If using this option, it is recommended to prepare a subset of your data that you want to include in the email.
Fields to Select
Add, remove, and arrange the columns to be included in the data table. For each column, select the data store field and specify a label. The order of columns determines their left-to-right placement in the table.
Best practices
- Variable usage: You can use process model variables in the subject
and body fields by referencing them with the
${variableName}syntax. -
Null values: If a data store field contains null values, consider
using the
COALESCEfunction in an analysis to replace nulls with a default value before including them in the notification. - Data volume: If the data store contains more records than should be included in the email, consider applying a row limit or filter in your analysis or data store configuration.