The CreatorCon Call for Content is officially open! Get started here.

Display dependent reference field based on selection in Service Portal

Hari7
Kilo Guru

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:

find_real_file.png

 

SubCategory Variable:

find_real_file.png

Service Portal:

find_real_file.png

Choice (sys_choice table) List Values:

find_real_file.png

 

1 ACCEPTED SOLUTION

Hi,

update as this in adv ref qualifier

dot walk current.variables.category.value

Regards
Ankur

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

View solution in original post

10 REPLIES 10

Thats fine Ankur. This is what made me clueless on how one is working and how the other one is not working where they both share the same code logic. 

Anyways thanks for your support. I will close this case.