Get values from referencing table in notification

[Mike D1]

Hi 

We have a survey record on asmt_assessment_instance table that gets triggered when an incident is resolved.

I have a new requirement that when the survey instance is completed a notification gets sent to the incident assignee with the asmt_assessment_instance_question values.

I can see asmt_assessment_instance_question is referencing asmt_assessment_instance however my issue is trying to add the variable values from the asmt_assessment_instance record. They aren't showing in the tree picker??

Is there another way to pull these values in to the notification?

Thanks

Mike

[Mike D1]

Hi Jaspal

Thank you that is great, there is one thing I am still struggling with is the first question has string_value not value. How can I amend the query to get this for the first quesiton?

[Mike D1 · Accepted solution]

I worked out a way by adding on from Jaspal's script in the end to show both metric values, in case anyone else has the same requirement. This might not be the most efficient way, but it works.