Built something you're proud of? Tell the story. A quick G2 review of App Engine or Build Agent helps other developers see what's possible on ServiceNow. Share your experience.

specific entity is choosed then other roles should be hidden

VinushaN0004809
Tera Contributor

bu_sls is reference field referring to orgit table and roles is list collector feild,list table is referring to question_choice table 
if specific subscope is choosed from bu_sls field then specific roles will populate as multiple choices 
There is no relation between table and roles 

1 REPLY 1

Naveen20
ServiceNow Employee
Try this approach
1. Create a mapping table with two reference fields: one to orgit, one to question_choice. Populate it with valid bu_sls → roles combinations.

2. Client-callable Script Include that takes a bu_sls sys_id and returns a comma-separated list of matching role sys_ids from the mapping table.

3. Reference qualifier on the roles list collector using sys_idIN + the Script Include result, so only mapped roles appear in the slushbucket. Return like NOREC when bu_sls is empty so nothing shows up.

4. onChange client script on bu_sls to clear the current roles value and force the list collector to re-evaluate the qualifier