Custom ${URI_REF} link not working

[matthew_hughes]

Within my workflow, I've specified an event that takes the user to a certain record in the 'sc_req_item' table if a request has been cancelled by specifying 'grEvent.uri' in the below code:

 

The below is my notification:

 However, when the email notification is generated, the ${URI_REF} instead takes the user to the 'sysapproval_approver' record, which is not what I want.

What do I need to do in my notification or workflow so that it takes the user to the URL specified in 'grEvent.uri' 

[Michael Fry1]

You need to define the URL you want to take the user too. See example here: https://www.servicenow.com/community/developer-forum/getting-uri-ref-to-display-incident-number/m-p/... 

[matthew_hughes]

Hi @Michael Fry1 I tried that and unfortunately I couldn't find the answer I was looking for. I did try using 'sc_req_item&sys_id=${event.parm1}&view=sp' in my link but '${event.parm1}' only shows number. How would I get it to show the sys_id?

[Ankur Bawiskar]

@matthew_hughes 

your notification is on sysapproval_approver table so ${URI_REF} will take user to Approval record and not RITM record

please use email script and form the URL and then include that email script in email body

[matthew_hughes]

Would you have an example on how to form the link?