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,

category variable is of what type?

since it's reference type you need to get the value of it so that you can use it in advanced ref qualifier

Regards
Ankur

[Hari7]

Hi @Ankur Bawiskar ,

Please find the below screenshot of the Record Producer variables.

I tired the subcategory variable as reference and it didn't worked. So, I have changed it to Lookup select but still no luck. 

[Ankur Bawiskar · Accepted solution]

Hi,

update as this in adv ref qualifier

dot walk current.variables.category.value

Regards
Ankur

[Hari7]

Hi Ankur,

This is working and I will mark the answer as correct answer but please let me know why this logic was working well for category where I didn't do the dot walking and why we need to do the dot walking on sub-category.