List collector

[sriramsin]

Hi Guys 
I have created a record producer , in that i created a field with list collector , like when i select the options and submit the record , then it stores the option as some numbers . I don't get the name of those choices in that field.

Thanks in advance 
Sri

[sriramsin]

list collector is referring to sys-group table , and the target is my custom table , in the record field  i gave the refrence qualifier as [element=u_requested_item^ORDERBYDESCsys_updated_on]

[Ankur Bawiskar]

@sriramsin 

So list collector shows choices and user selects multiple choices

List collector holds sysIds

are you saying here in this below image it is showing sysId?

how are you setting/creating that record? are you mapping it?

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[sriramsin]

Yes ,actually through the record producer in creating the record by mapping the fields of my custom table . then usage of the list collector , needed the sys_choice table and then i got query from the table of my choices .
then i put the query as the refrence qualifier in the variable of the record producer .
Whenever the user selects the record , it shows as the sys_id of the choices in the table , is there any ways to get the name of the choices and populate in the field?

[Ankur Bawiskar]

@sriramsin 

why not make that target table field as reference to sys_choice?

how are you mapping it because list collector holds more than 1 value but your target field is choice?

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[Tanushree Maiti]

Hi sriramsin,

• You need to go the referenced table which you are referencing .
• Locate the field you want to be the display value i.e. Name
• open that field in the dictionary and set "display" to true

Warning: This change is global. In other catalogs where there requirement was to see number, they will get it as Name