Filter reference field based on another reference field in catalog item

[Community Alums]

Hi,

I am modifying existing catalog item "Create item" to include some of the custom fields we added in Case.

I have 2 custom fields Case Category and Case Subcategory as below in the variables.  

Category is filtered down based on the javascript below and works correctly

javascript:'u_is_parent_category=true^u_departmentISEMPTY^ORu_departmentLIKE' +current.contact.department

SubCategory is not filtering the list based on the category selection. It shows everything.  Can you please tell me what I am doing wrong? Thank you

Here is what I have for Case Category

This is for Case Subcategory

[rahulpandey · Accepted solution]

Hi Angel,

1)- Category filter seems wrong. it should be like below

javascript:'u_is_parent_category=true^u_departmentISEMPTY^ORu_departmentLIKE' +current.variables.contact.department

2)- What is the relationship between category and subcategory ? is category  is parent of subcategory  ? What is field that represents the category and subcategory relationship ?

In subcategory reference qualifier, you have not mentioned anywhere to consider category. 

[Community Alums]

Category is the parent of subcategory. 

I modified the javascript for subcategory as below and that appears to work

javascript:'u_is_parent_category=false^u_departmentISEMPTY^ORu_departmentLIKE' +current.contact.department+'^u_parent_category='+current.variables.u_case_category

[rahulpandey]

Perfect, I am glad, I could help.