How to export embedded table with current data to excel?

Nana5 · ‎05-31-2017

Hio expert need to the embedded table export to excel with current data.Please help me out to achive this.

Table:

Thanks

Nana5 · ‎06-01-2017

HI ALL,

I got the solution now its working fine.

runContextAction();

function runContextAction() {

var sysparm_rows = g_list.grandTotalRows;

var num_rows = parseInt(sysparm_rows);

var sysparm_query = 'u_parent_request=' + g_form.getUniqueValue();

var tableName = 'u_single_or_multiple_invoice_request';

var sysparm_view = g_list.view;

if (num_rows < g_export_warn_threshold) {

var dialog = new GwtPollDialog(tableName, sysparm_query, sysparm_rows, sysparm_view, 'unload_excel_xls');

dialog.execute();

return;

}

var dialog = new GwtExportScheduleDialog(tableName, sysparm_query, sysparm_rows, sysparm_view, 'unload_excel_xls');

dialog.execute();

}

Regards,

Prakash Ranjan

View solution in original post

Dave Smith1 · ‎05-31-2017

If you click on a table heading menu, is there an "export" function there?

Also - why export data from the platform OUT into Excel?

Nana5 · ‎05-31-2017

Hi Dave,

There is no export but i have added there context menu, but thing is that its export the orld data as well but i nedd current data of the table which is displying.

NB: AS per requirment need to export the data.

Thanks

Shishir Srivast · ‎05-31-2017

Hi Prakash,

Please check if this helps.

https://www.servicenowguru.com/system-ui/enabling-related-list-exports-servicenow/

Simple Excel Extraction of Related Lists from Form View

Nana5 · ‎05-31-2017

Hi Shishir,

I belive you didn't get my requirment.

I have created the context menu for the embaded table as below to exoport the data but its exporting all the data to excel but i need to export current data which is displaying in embedded table.

context menu.:

var sysparm_rows = g_list.totalRows;

var num_rows = parseInt(sysparm_rows);

var sysparm_query = g_list.getQuery({orderby: true, fixed: true});

var sysparm_view = g_list.view;

if (num_rows < g_export_warn_threshold) {

var dialog = new GwtPollDialog(g_list.tableName, sysparm_query, sysparm_rows, sysparm_view, 'unload_excel');

dialog.execute();

return;

}

var dialog1 = new GwtExportScheduleDialog(g_list.tableName, sysparm_query, sysparm_rows, sysparm_view, 'unload_excel');

dialog1.execute();

but this export exporting all the data which is avilable in single or multiple table but i need to to export only displayed data which is currently displaying on the table.

Thanks