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.
