How to show the survey notification under "Emails" related list

mania
Tera Contributor

Hi,

How to show the survey notification under "Emails" related list in sn_hr_core_case table.

1.Created the "Emails" relationship.

mania_0-1744898424511.png

 

2.By using this code as per above screenshort i am able to see all the sn_hr_core_case table related emails this is fine.

mania_1-1744898424528.png

 

3.But i want to able to see the survey notification as well as below:

mania_2-1744898424529.png

 

 

And the survey notification is asmt_assessment_instance table.

So how to include the survey notification to "Email" related list.

mania_3-1744898424535.png

 

 

Can anyone please help on this, it will be usefull.

Thanks!

2 REPLIES 2

Ankur Bawiskar
Tera Patron
Tera Patron

@mania 

you will have to query "asmt_assessment_instance" table with the HR case sysId and then check in emails table if any email triggered for that survey record

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

@mania 

Hope you are doing good.

Did my reply answer your question?

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader