Hi Subhanand,
Following script you can use in UI page
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">
<g:evaluate var="jvar_instanceName" object="true">
var instanceName = gs.getProperty('instance_name');
instanceName;
</g:evaluate>
<g:ui_reference name="tables" id="tables" table="sys_db_object" completer="AJAXTableCompleter"/>
<input type="hidden" id="hidden" value="${jvar_instanceName}"/>
<input type="button" value="Download Excel" onclick="download()"></input>
</j:jelly>
Client Script:
function download(){
var instanceName = gel('hidden').value;
var table = gel('tables').value;
var tableGr = new GlideRecord('sys_db_object');
tableGr.addQuery('sys_id', table);
tableGr.query();
if(tableGr.next()){
var url = 'https://' + instanceName + '.service-now.com/' + tableGr.name + '_list.do?XLS';
window.open(url);
}
}
Care to be taken since it doesn't specify any query so it will try downloading all records. you can specify the view as well so as to include only necessary columns using sysparm_view parameter in URL
Mark Correct if this solves your issue and also mark Helpful if you find my response worthy based on the impact.
Thanks
Ankur
Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
