HI All.

I need to copy all variables from a catalog item(portal form) to sc_task description field. there for i'm using the next business rule (along a client script) which works OK except for list collectors. I'm getting a sys_id as value if catalog items are containing a list collector.

This is the BR code which I use to copy variables to task description:
Can someone please help me with this script so I can convert list collector sys_id's to display value?

(function executeRule(current, previous /*null when async*/) {
//Initialize the scratchpad variable
g_scratchpad.varJSON = '';
var type, name, value, reference, val, item;
//Check to see if a variable pool exists
var count = 0;
for(vars in current.variable_pool){
count++;
break;
}
//If a variable pool exists then collect variable names and values
if(count > 0){
var varJSON = {};
var table = current.getTableName();
//Catalog item and task variables pull from 'sc_item_option_mtom' table
if(table == 'sc_req_item' || table == 'sc_task'){
var itemVars = new GlideRecord('sc_item_option_mtom');
if(table == 'sc_req_item'){
itemVars.addQuery('request_item', current.sys_id);
}
if(table == 'sc_task'){
itemVars.addQuery('request_item', current.request_item.sys_id);
}
//Exclude Label and Container variables
itemVars.addQuery('sc_item_option.item_option_new.type', '!=', 11);
itemVars.addQuery('sc_item_option.item_option_new.type', '!=', 19);
itemVars.addQuery('sc_item_option.item_option_new.type', '!=', 20);
// Set Order
itemVars.orderBy('sc_item_option.order');
itemVars.query();
while(itemVars.next()){
//Add variable names and values to the varJSON object
type = itemVars.sc_item_option.item_option_new.type.toString();
name = itemVars.sc_item_option.item_option_new.question_text.toString();
val = itemVars.sc_item_option.value.toString();
// Reference
if (type == 😎 {
reference = itemVars.sc_item_option.item_option_new.reference.toString();
value = getReferenceDisplayValue(reference,val);
}
// Select Box
else if (type == 5) {
item = itemVars.sc_item_option.item_option_new.sys_id;
value = getChoiceDisplayValue(item, val);
}
// Default
else {
value = val;
}
// Replace blank values with [None]
if (value == '') {
value = '[None]';
}
varJSON[name] = value;
}
}
//All other variables pulled from 'question_answer' table
else{
var producerVars = new GlideRecord('question_answer');
producerVars.addQuery('table_sys_id', current.sys_id);
//Exclude Label and Container variables
producerVars.addQuery('question.type', '!=', 11);
producerVars.addQuery('question.type', '!=', 19);
producerVars.addQuery('question.type', '!=', 20);
producerVars.addQuery('question.type', '!=', 24);
// Set Order
producerVars.orderBy('order');
producerVars.query();
while(producerVars.next()){
//Add variable names and values to the varJSON object
type = producerVars.question.type.toString();
name = producerVars.question.question_text.toString();
val = producerVars.value.toString();
// Reference
if (type == 😎 {
reference = producerVars.question.reference.toString();
value = getReferenceDisplayValue(reference,val);
}
// Select Box
else if (type == 5) {
item = producerVars.question.sys_id;
value = getChoiceDisplayValue(item,val);
}
// Default
else {
value = val;
}
// Replace blank values with [None]
if (value == '') {
value = '[None]';
}
varJSON[name] = value;
}
}
// Convert varJSON into a string and store the result in the scratchpad
g_scratchpad.varJSON = JSON.stringify(varJSON);
}
// Function to convert reference value to display value
function getReferenceDisplayValue(table,value) {
var displayValue1 = '';
var gr1 = new GlideRecord(table);
gr1.addQuery('sys_id',value);
gr1.query();
if (gr1.next()) {
displayValue1 = gr1.getDisplayValue();
}
return displayValue1;
}
// Function to convert choice value to display value
function getChoiceDisplayValue(item_option,value) {
var displayValue2 = '';
var gr2 = new GlideRecord('question_choice');
gr2.addEncodedQuery('question=' + item_option + '^value=' + value);
gr2.query();
if (gr2.next()) {
displayValue2 = gr2.text + '';
}
return displayValue2;
}
})(current, previous);

Thanks in advance.