Download all active incidents in Excel xlsx format using ui page?

arey yaar · ‎10-23-2018

I need to download all active incidents of the incident table in the xlsx format ,When a button is clicked.Need to do this in ui page..

Ahmmed Ali · ‎10-24-2018

Hello,

sorry, i was checking the this in simple html page.

for UI page, below thing worked for me.

html:

<?xml version="1.0" encoding="utf-8" ?>
<j:jelly trim="false" xmlns:j="jelly:core" xmlns:g="glide" xmlns:j2="null" xmlns:g2="null">

<button type="button" onclick="downloadIncidents()">Click Me!</button>

</j:jelly>

client script:

function downloadIncidents(){
window.location.href='https://instanceName.service-now.com/incident_list.do?sysparm_query=active=true&EXCEL';
}

This should work for you also.

Thanks,

Ali

If I could help you with your Query then, please hit the Thumb Icon and mark my answer as Correct!!

Thank you,
Ali

View solution in original post

Kalaiarasan Pus · ‎10-23-2018

There is already an export button available on list view that allows you to download the data in different formats. Why not just use it instead of building something custom?

arey yaar · ‎10-23-2018

i need to do this in ui page. When i click on the button in the ui page it should download all the active incidents..in Excel xlsx format

Kalaiarasan Pus · ‎10-24-2018

Why can't you just show the link to report to the user or redirect them to report? Is there a specific reason you want to build the page?

arey yaar · ‎10-24-2018

I have the Requirement to download the active incidents in Xlsx format,not by sending link..so that it can be edited for further use...