How to dot walk from requested item form to catalog task related list field?

johannes5 · ‎01-12-2015

Hi ServiceNow Community Developers,

I have the following situation - I have a Requested Item form (sc_req_item table) that has catalog task (sc_task table) related list. When the work notes changes in the Requested Item form I need to send a notification to the assignment group that is in the catalog tasks related list. Would you please advise as to how do I dot walk from the sc_req_item table to the sc_task table to pick up the assignment group that is in this table and specify that as the group i want emails to be sent to. . I can see the 'Show related fields' link but I cannot tell which field to choose that will let me dot walk to the assignment group that is defined in the catalog task (sc_task) table. Please help.

Thanks,

Johannes

randrews · ‎01-12-2015

you can only dot walk from a child to a parent... which is why this didn't work...

how to get the additional recipients isn't to hard.. write a mail notification script that looks up the people that have tasks assigned to them with that item as a parent then use "email.addAddress("cc",splitThis[i]);" to add the user to the email <put the user in where i have splitThis array>

View solution in original post

johannes5 · ‎01-13-2015

Yes I can see all the sys_ids in the 'copied' field. This is good at least the script is working fine. Do you know then Doug how come the system can't send an email to these sys_ids?

I greatly appreciate your help.

Thanks,

Johannes

johannes5 · ‎01-13-2015

I am all set. Thank you very much to all of you for your help. This was a huge achievement on my part and I only got this functionality to work because of you guys.

Greatly appreciated.

Johannes