
function exporttoExcel() {
var sysparm_rows = g_list.grandTotalRows;
var num_rows = parseInt(sysparm_rows);
var selSysIds = g_list.getChecked(); // This will return the sys_id of the selected records
var sysIdList = selSysIds.split(',');
var sysparm_query = "";
for(var i=0; i<sysIdList.length; i++) {
if(sysparm_query != "") {
sysparm_query = sysparm_query +"^OR" +"sys_id=" +sysIdList[i]; // Passing sys_ids to sysparm_query
} else {
sysparm_query = "sys_id=" +sysIdList[i];
}
}
var tableName = 'incident'; // Table Name for which the records needs to be exported
var sysparm_view = g_list.view;
// If the records are less then export threshold GwtPollDialog will export the records in .xls format
if (num_rows < g_export_warn_threshold) {
var dialog = new GwtPollDialog(tableName, sysparm_query, sysparm_rows, sysparm_view, 'unload_excel_xls');
dialog.execute();
return;
}
// If the records are more then export threshold GwtExportScheduleDialog will export the records in .xlsx format
var dialog = new GwtExportScheduleDialog(tableName, sysparm_query, sysparm_rows, sysparm_view, 'unload_excel_xls');
dialog.execute();
}
Code replicate Export as Excel in incident from list view ServiceNow
Working Code Asked question December 20, 2024
Sorry, you do not have permission to read comments.