I want to generate a pdf of selected records in a list?

trinadhgottipat · ‎02-14-2017

Hi All,

I want to generate a PDF of selected records in a list, when the user clicks on 'Generate PDF' UI action(List Choice),created by me.

Is there a way I could do this.

Thanks,

Trinadh.Developer Community Service Management dvp Chuck Tomasi's Blog Pradeep Sharma's Blog ctomasi

Ankur Bawiskar · ‎02-15-2017

Hi Trinadh,

Have a List UI Action either List bottom button or List context menu as per your need.

Select the checkbox for client and add this function downloadPdf()

In the script section add the following code. What it does is it gets the pdf for only those records which are selected in the list layout.

I have tested it at my end and is working fine. It will take columns specific to a view and not the ones which you have added from gear icon.

If you want the columns which are present on the list layout then make the view as empty

Script

function downloadPdf(){

var checked = g_list.getChecked(); // get's the sys_id of the checked records

var query = "sys_idIN" + checked.toString();

var rows = checked.split(",").length; // rows to be sent to the pdf function

var view = "default"; // set this to default for columns present in default view for list layout

//var view = ""; // set this to empty if you want all the columns present in the list layout including the customized ones.

var dialog = new GwtPollDialog('u_sample_table', query, rows, view, 'unload_pdf');

dialog.execute();

}

Mark Correct if this solves your issue and also hit Like and Helpful if you find my response worthy based on the impact.

Thanks

Ankur

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

View solution in original post

trinadhgottipat · ‎02-15-2017

But how can I query the list of records i have selected from the list.

dvp · ‎02-15-2017

You can do it in two ways

1. add created by field to list and right click on column and do show matching

2. Create a new module and set created by dynamically

trinadhgottipat · ‎02-15-2017

I want the pdf generation to happen from the UI action,i,e when i check some records in the list and click the ui action in list choice.My requirement is not about using filters.

SUKANYA5 · ‎02-04-2020

i want to create a form action button to generate custom table all records in pdf format.can u help me please