The CreatorCon Call for Content is officially open! Get started here.

How to export embedded table with current data to excel?

Nana5
Mega Guru

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

Table:

find_real_file.png

Thanks

1 ACCEPTED SOLUTION

Nana5
Mega Guru

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

6 REPLIES 6

Nana5
Mega Guru

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


is it possible to refere to the "view" from the related list? It has the same name as the normal view. Only difference is that the view of the embedded list has a "parent" object.

I'd like to be able to export the columns from the related list