Dynamic refence qualifier for record producer

[rmaroti]

hello, I have two reference type variable i.e  name is 'request_regarding' and 'category' on Record Producer one is referencing to "Topic Category" and another one is referencing to "Topic Details" table when I select topic category in only its child topic details should be visible I have tried bit it not working.

Pls find attached screenshot and let me know where I need to change it.

for this requirement I'm creating dynamic reference qualifier but its not working.

but i got all topic details not child one of topic category.

table name- Topic Category -sn_hr_core_topic_category

                      Topic Detail -sn_hr_core_topic_detail

[_Gaurav]

Hi @rmaroti 

Can you please try to change LINE 14 of your script include from arr.push(gr.name) to arr.push(gr.sys_id);

[rmaroti]

actually name field is translated text type of field so still we need to use it sys _id