Data access issue on Reference variable on Record Producer

[rmaroti]

Hi All,

Requirement: I have one record producer in which reference variable which backend name is topic_category on "Topic Category" table when I'm selecting the dropdown I'm getting value as per reference qualifier apply on the particular topic_category variable when user has admin role access but when user don't have admin role it has access of (snc_internal) role access at that time in dropdown I'm getting few record data which is a topic category for only one application scope when I tested so my question is -

1) I want for other application scope record data on topic category table as well then what I need to do.

2)There will be ACL on topic category for (snc_internal)  role user because when I checked on list view very less record data shown up 3-4 and dropdown I can see 8 record data on record producer.

[Anwesha3]

Hi @rmaroti 
how many records are there for Topic category ?
Instead of using reference qualifier you can try for look up select box and do scripting to add dropdown values on the look up field. 
g_form.addOption  - can be used to set the dropdowns  ;