You can store SQL queries as data sources for e-mail templates. The email template uses data coming from the data source.

You need SQL knowledge to create data sources.

Create a data source

Select the object type from the drop-down menu next to "Type" in the area . You can enter the designation in several languages in the table within the column "Translation". Click on the line you want to edit the object type for.

Depending on the object type for which the data source was selected, various parameters are available. After saving the information, call up the parameters via the -button.

If your SQL returns multiple data records, the first record is used in the email template.

Define the data source

Switch to to type in the SQL query in the text editor. The text editor highlights keywords such as 'SELECT', 'FROM' or 'WHERE' in colour. If you insert a parameter, use it in the text editor with a preceding '@'. Parameters are 'case sensitive'. If the text editor detects parameters, they are displayed to the right of the text editor in the main window. Unknown parameters are highlighted in yellow. Each parameter has a text box in line where you can enter values. Start the query with a click on the -button. Missing values can be entered afterwards and they must be confirmed with the -button.