Generate multiple PDF reports at once from List View

Srinika · 3 weeks ago

I have a requirement to generate multiple PDF's at once from list of cases. Should be able to click on the checkboxes of the cases and add "Generate PDF" button.

In the PDF I want details from Case table and survey table. Can someone kindly help me on this requirement.

Muhammad Salar · 3 weeks ago

Hello @Srinika ,

I have done this on knowledge articles table, you can modify this script as per your need. Try this

UI Action:

UI Action script:

function test() {

var sysId = g_list.getChecked();

var a = new Array();

a = sysId.split(",");

var b = a.length;

var ga = new GlideAjax('GetKnowledgeArticleBody');

ga.addParam('sysparm_name', 'getHtml');

ga.addParam('sys_id', a.toString());

ga.getXML(getRequired);

function getRequired(response) {

var answer = response.responseXML.documentElement.getAttribute("answer");

var json = JSON.parse(answer);

for (var i = 0; i < json.length; i++) {

window.open('/sys_attachment.do?sys_id=' + json[i].id);

}

window.setTimeout(fun2, 3000);

function fun2() {

var att = new GlideRecord('sys_attachment');

att.addQuery('table_name', 'kb_knowledge');

att.addQuery('table_sys_id', 'IN', sysId);

att.orderByDesc('sys_created_on');

att.setLimit(b);

att.query();

while (att.next()) {

att.deleteRecord();

}

}
I have used fun2 for deleting attachments from the record after downloading, if you don't want it, remove it.

Script include function:

getHtml: function() {

var hfInfo = new Object();

hfInfo["FooterText"] = "Test";

hfInfo["PageSize"] = "A4";

hfInfo["GeneratePageNumber"] = "true";

hfInfo["TopOrBottomMargin"] = "60";

hfInfo["LeftOrRightMargin"] = "42";

hfInfo["PageOrientation"] = "PORTRAIT";

var list = [];

var sysId = this.getParameter('sys_id');

var gr = new GlideRecord('kb_knowledge');

gr.addQuery('sys_id', 'IN', sysId.toString());

gr.query();

while (gr.next()) {

var object = {};

var name = gr.getDisplayValue('short_description');

var v = new sn_pdfgeneratorutils.PDFGenerationAPI;

var result = v.convertToPDFWithHeaderFooter('<h1>' + gr.getDisplayValue('short_description') + '</h1>' + '<p style="margin-top:-20px;">' + gr.getDisplayValue('number') + '<b>' + ' . ' + '</b>' + gr.getDisplayValue('version.version') + '<b>' + ' . ' + '</b>' + gr.published + '</p>' + '</p>' + '<div style="margin-top:-30px;">' + gr.getValue("text") + '</div>', 'kb_knowledge', gr.getUniqueValue(), name, hfInfo);

object.id = result.attachment_id;

list.push(object);

}

return JSON.stringify(list);

},
Used PDFGenerationAPI to attach pdf to record.

View solution in original post

ben_hollifield · yesterday

Hi @Srinika,

If you'd prefer a turn-key solution, Yansa Labs has a certified app on the ServiceNow Store for exactly this purpose. You can check the links below for more information. Feel free to reach out to Yansa Labs directly with any questions!