How to store multiple values in a scratchpad and print it in the catalog task description

[Koyel Guha]

Hi,

Could you please help on the below code to print multiple values from multiple dynamic tasks in single line with comma and store it in the scratchpad to use it to the catalog task description.

var getsc = new GlideRecord('sc_task');

getsc.addQuery('request_item', current.sys_id);

getsc.addQuery('u_asset_details' ,'!=', "");

getsc.addQuery('short_description' , "XXXX");

getsc.addQuery('u_assets_returned' , "No");

getsc.query();

while (getsc.next()) {

workflow.scratchpad.assetdetails=getsc.u_asset_details.u_computer_name;

workflow.scratchpad.serialnumber=getsc.u_asset_details.serial_number;

workflow.scratchpad.assets = '';

var str = workflow.scratchpad.assetdetails + " - " + workflow.scratchpad.serialnumber;

    array = [];

    array = str.split(",");

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

workflow.scratchpad.assets += array[i];

}

}

I am getting the details below when I am trying in BG , It should print all these in single line comma separated.

Could you please help. 

Thanks.

[Brad Bowman · Accepted solution]

This should get you closer:

var assetArr = [];
var getsc = new GlideRecord('sc_task');
getsc.addQuery('request_item', current.sys_id);
getsc.addQuery('u_asset_details' ,'!=', "");
getsc.addQuery('short_description' , "XXXX");
getsc.addQuery('u_assets_returned' , "No");
getsc.query();
while (getsc.next()) {
    assetArr.push(getsc.u_asset_details.u_computer_name + " - " + getsc.u_asset_details.serial_number);
}
workflow.scratchpad.assets = assetArr.join(',');