Jump to content

Email Templates - Added child to Request Entity - Questions

Martyn Houghton

Recommended Posts

At the moment with Email Templates you can use the Request Entity to insert variable into the template. However the entity does not include the child table Request Questions, so you are not able to use any of the custom form values entered in the Progressive Capture.

Can a Request for Change be logged to add the Request Questions child table be added to the Request Entity. I also suspect the same relationship will be required for Reporting as well.



Link to comment
Share on other sites

Hi Martyn

This has been brought up internally a number of times and the issue is Mail Template variables only support One to One relationships and Questions are One to Many so how would you map a question to a template variable?

I will bring this up with out platform team again and let you know.

Kind Regards

Trevor Killick

Link to comment
Share on other sites


Thanks for the quick reply. I think this does highlight an issue around the naming/referencing of customised Questions and their corresponding responses. When you use the Get Question BPM Task it only gives a list of Answer1, Answer2 etc rather than using the field labels specified in progressive capture process.

I was presuming that at least the same functionality of inserting Answer1, Answer2 etc would be available.



Link to comment
Share on other sites


There are two problems with this...

* Trying to do this dynamically against entity relationships presents a problem inasmuch as a one2many relationship could easily involve a large number of records, some of our bigger entities can have 10 or more relationships so things can get very big very quickly.

* The syntax/markup in the template becomes unwieldy and difficult for people to use.

In the case of PG questions, it might be better to have some way to consolidate the questions into a single field for the purpose of including in a mail template. I believe @Trevor has already raised this internally for discussion.


  • Like 1
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...