Display dependent reference field based on selection in Service Portal

[Hari7]

We have 3 variables created in a Record Producer. 

1. "Service" - Reference Field - Table: cmdb_ci-service - Map to Field (Yes) - Mapped to Business Service field. 

2. "Category" - Reference Field - Table: sys_choice - Map to Field (Yes) - Mapped to Category field on an extended table of sn_customerservice_case. Dependent on Service Field

3. "SubCategory" - Lookup Select Field - Table: sys_choice - Map to Field (Yes) - Mapped to Sub Category field on an extended table of sn_customerservice_case. Dependent on Category Field

Used Reference Qualifier for Category and it works fine. Displays the value based on service selection.

Used the same logic for sub-category but no value is showing up. If I remove the Reference Qualifier then everything in the table shows up.

Please let me know what needs to be done here to show the subcategory value. 

Category Variable:

SubCategory Variable:

Service Portal:

Choice (sys_choice table) List Values:

[Ankur Bawiskar]

Hi,

can you share category variable advanced ref qualifier screenshot

Regards
Ankur

[Hari7]

I have the full page screenshot on the initial post but please find the below one for the category variable. 

[Ankur Bawiskar]

Hi,

business_service is what type?

can you share screenshot of configuration for it?

Regards
Ankur

[Hari7]

[Ankur Bawiskar]

Not very sure how it is working

Business service variable is reference type actually