SYS ID displaying in list collector from record producer

[Patrick Slatter]

Monring!

I am experiancing an issue with a list collector displaying the SYS ID instead of the display value. 

I have a list collector in a record producer that is using local choices (question_choice). This needs to log teh value and then map it into a list collector on the demand record that the record producer creates.

When this happens, it is placing the SYS ID into this field, instead of the display value. 

Any assistance would be greatly appriciated.

Thanks!

[BharathChintala]

@Patrick Slatter  I said remove and add again as I am sending replies from mobiles quotes are in wrong format  so just remove add again I said and also uncheck map to field check box in variable

also in line 36 current spell is wrong

[Patrick Slatter]

@BharathChintala Sorry for the confusion. Changes made and same result

Variable:

Script

 

Result 

[BharathChintala]

@Patrick Slatter I have modified  one more line in last reply as line 36 has spell mistake for current

[Patrick Slatter]

Removed the addition 'r' spelling error in line 36 

Same result 

[BharathChintala · Accepted solution]

@Patrick Slatter 

use below code in record producer script

var sys = producer.u_impacted_other_cross_functional_teams;
var list =[];
var gr = new GlideRecord('question_choice');
gr.addQuery('sys_id', 'IN', sys);
gr.query();
while(gr.next()){
list.push(gr.value.toString());
}
current.u_impacted_other_cross_functional_teams=list.toString();