I want to generate pdf of t a RITM variables

Juhi Jha
Tera Contributor

I want to generate pdf of t a RITM variables 

1 ACCEPTED SOLUTION

Hi,

you can add extra line to download it

var ritmSysId = current.sys_id;
var set = new GlideappVariablePoolQuestionSet();
set.setRequestID(ritmSysId);
set.load();
var vs = set.getFlatQuestions();

var valuesArray = [];

var csvHeader = [];

for(var i=0;i<vs.size();i++){

	var variableLabel = vs.get(i).getLabel();

	csvHeader.push(variableLabel.toString());

	var variableValue = vs.get(i).getDisplayValue();

	valuesArray.push(variableValue.toString());

}

var csvHeaderRow = csvHeader.toString();
var valueRow = valuesArray.toString();
var sa = new GlideSysAttachment();

var document = csvHeaderRow + "\n" + valueRow;

var ritmRec = new GlideRecord('sc_req_item');
ritmRec.get(ritmSysId);

var sysId = sa.write(ritmRec, "catalog_variables.csv", "text/csv", document);

action.setRedirectURL('/sys_attachment.do?sys_id=' + sysId);

Regards
Ankur

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

View solution in original post

17 REPLIES 17

I don't want to print empty variables in csv 

check for the value and compare

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

Sebaslag
Giga Expert

Hi! Did you find a solution to generate a PDF? I'm trying to do the same thing. Thanks