How to get values from a reference variable type to a list collector

[BCELSTEI]

Hi,

I've currently setup several check box on a catalog item to give the possibility to the user to choose several options but I need to reuse a reference field and be able to list values of my field in a "list collector" variable.

"Question_choice" table does not work if choices are not in the select box choice quetion.

My case:

I want those reference list values from the region field in the location table

in a list collector to give the opportunity to the user to have several choice but depending on values on this field

Thanks for your advise

[Ankur Bawiskar]

@BCELSTEI 

why not point that list collector to location table itself?

Users can select multiple locations and show the Region field while they select the value from list collector

If my response helped please mark it correct and close the thread so that it benefits future readers.

[BCELSTEI · Accepted solution]

Hi Ankur, Thanks for your reply. In fact, the business needs is to choose the region directly. But I've found the way to do it.

I used the "sys_choice" table, reference qualifier "name=cmn_location^element=u_area^inactive=false"

where name is the table, element the field name and only vae the active value.

Result