Hi,
I am stuck at advance reference qualifier for variable
I am working on an advanced reference qualifier for a Service Catalog variable, but it’s not working as expected.
I have two variables:
Agora Team – Select Box (single select)
Select Role – List Collector (multi-select)
The Select Role variable references the sys_choice table.
Data setup:
In sys_choice:
The Value field stores the Agora Team value
The Label field stores the Role name
Each Agora Team can have multiple associated roles.
Requirement:
When a user selects a value in Agora Team, the Select Role (List Collector) should display only the roles (labels) that are associated with that selected team (based on matching value in sys_choice).
Issue:
I have written an advanced reference qualifier, but it is not filtering the roles correctly based on the selected Agora Team.
Refrence qualifier
Screenshot from sys_choice table record
Screenshot from the portal variable
Looks like the qualifier is using the wrong field. current.variables.agora_team returns the selected value, so you should match that against dependent_value in sys_choice, not label. Also make sure element uses the variable’s internal name, not the question text, and add ref_qual_elements=agora_team on the list collector so it refreshes properly.
Here you go!
Let me know if you have any questions,
if it helped please mark this helpful and accept the solution
