Lookup Select - Question choice table

[Jai2021]

Hi all,
I need to pull a  question and it's choices for a catalog item from question choice table. But it's not working as expected. Can anyone help me.
Variable type: Look up select box
Question : Select from the below option
name: u_demo
look up from table: question_choice
look up value field:Value
look up label field: text
include none : true
unique values : true
Ref qual : question='sys_id of question'

Need immediate help
Thanks!

[Musab Rasheed · Accepted solution]

Hello,

Question choice table has several entries, you need to define proper criteria to pull values. In my case I'm pulling all choices with respect to another question and same you have to add in Reference qualifer.

Please hit like and mark my response as correct if that helps

Regards

[Jai2021]

Yes ,I did in this way .But not working, only the none option is showing in the form not the choices belongs to the question

[SunilKumar_P]

Please check the READ ACLs on the 'question_choice' table. READ ACLs may be restricting the visibility of the records from 'question_choice' table.

[Rafał Rataj]

yup,

the question_choice is restricted to 

catalog_manager

catalog_editor

+

survey_admin

catalog_admin

catalog_builder_editor

survey_reader

the funny thing is that the Select Box ignores the ACLs
while the List Collector will respect them