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