How to configure a cascading Interactive Filter for Service → HR Service → HR Category on a Universal Request dashboard?
I am trying to configure a Cascading Interactive Filter on a ServiceNow dashboard based on Universal Request [universal_request].
My Requirement is
Service
↓
HR Service
↓
HR Category
The expected behavior is:
When Service = HR is selected, the relevant HR Services should be available.
When an HR Service is selected, the HR Category dropdown should dynamically display only the categories related to that HR Service.
For example:
Service = HR
↓
HR Service = Benefits
↓
HR Category =
Benefits Appeal
Benefits Enrollment/Removal
Dependents/Beneficiaries
If the user changes the HR Service to Employee Documents, the HR Category list should refresh and show only categories belonging to Employee Documents.
The fields are on Universal Request:
Service: u_service
HR Service: u_hr_service
HR Category: u_hr_category
The underlying relationships are:
HR Service → Service
HR Category → HR Service
I have created a Cascading Filter with three levels
Service
└── HR Service
└── HR Category
However, I am not sure how to correctly configure the Table, Display Field, Parent Reference Field, and Target Tables for each level.
