Building a delivery template contents from a table/static list

[RajeshBhat]

Looking to build a delivery template from a static list or a schema within ACC which holds a master data. The values in this list/schema will get populated into a table within the email body. Once the full content of the email template is ready then based on the flag values in targetData the rows of the email table will be shown/hidden. I don't want to link the master data with targetData upfront as there is no mapping (common) field across two data sets and also the cross join will significantly increase the record count.

Any suggestions/guidance in achieving this will be appreciated!

[_Manoj_Kumar_]

Hello @RajeshBhat  My suggest would be to create a  workflow to achieve this. If you will try to add queryDef within in the delivery template, it won't work. Any script/code added in delivery template should be executed within 5 seconds otherwise it will timeout.