Is there a way to add record reference link in exported excel report?

[RKumar3]

Hi All, I have a requirement wherein I need to export an excel report on problem table. I am able to export the report appropriately except the fact that I am not able to export the link to problem records. I am only getting the Problem record number in the xls but not the reference link so that user can click the reference link directly from the excel and open the problem record in ServiceNow. Anyone has done something like this before? Many thanks in advance. Regards, Rajnish Kumar

[RKumar3]

Thanks William, I hope I will get some way to do this 🙂 Rajnish

[krishna_yadav]

Hi Rajnish,

Could you please provide the detail how to get the problem record number hyperlinked with its url?

Regards,

Krishna

[williamsun]

Hi Krishna,

Try this wiki page:

Navigating by URL - ServiceNow Wiki

It covers how to do it with the options and parameters.

The syntax is like this:

https://<base URL>/nav_to.do?uri=<page name>.do?sys_id=<sys_id>%26<page parameters>

You can take a shortcut by adding the ${task.URI_REF} parameter in an email notification and then taking a look at how that is constructed, for example, this is one for an incident notification:

https://yourinstance.service-now.com/nav_to.do?uri=incident.do%3Fsys_id=374d02176fe979003a4d508e5d3e...

[sriihs]

Hi,

I just tried out the steps mentioned in this post, however I keep getting this error as displayed in the screenshot below. Any pointers on what must be wrong?

Thanks,

Sowmya

[williamsun]

This is the new syntax checker.

The semicolon it's looking for is at the end of the line.   Add a ";" at the end;

Although, I think the orange dots are "warning" and it should work like that.