Include link to task when exporting a report

[Brian Lancaster]

Is there a way to export a list of lets say incidents and have the number field be a link to the incident?

[Amit Verma]

Hi @Brian Lancaster 

The solution provided by Greg in the below post might act as a starting point to you :

https://www.servicenow.com/community/developer-forum/export-a-list-and-include-the-url-to-the-record...

Thanks and Regards

Amit Verma

[Brian Lancaster]

That doesn't seem to work anymore. When I put this in instance https://instance.service-now.com/incident_list.do?CSV&sysparm_default_export_fields=all nothing happens and then eventually the URL goes back to pa_dahsboard.do. Also I'm not sure how this would give me the URL.

[Bert_c1]

hmm, I tried the link in my PDI and got the csv file in my Downloads folder. It took about 2 minutes. And there was an indication of the download in progress in the upper-right corner of my browser. I got all 6892 incident records.  However, there is no link there. Seems you could add the url used in the spreadsheet (copy-and-paste) if you wanted to include that in the file. Or open the csv file in a text editor and replace all on ',"INC' with something like

',"https://devXXXXXX.service-now.com/incident_list.do?sysparm_query=number%3DINC'.  Not ideal as it takes a few steps. But it worked for me. The resulting values in the number field when placed in my browser's address bar worked.

[Brian Lancaster]

This is for a manager who will be doing audit of Random incident using this community post. I don't think he would like it if I added more work to what he already had to do for the report.