how to create two interactive filters , one filter choice controls the other filter choices

[sunkarasath]

hello team ,

so i need to create 2 interactive filters on dashboard which are business services and assignment group , the dashboard created on incident table , i need like if i choose any business service (cmdb_ci_service) so it automatically changed the drop down of the assignment group filter  as only shows assignment groups which are belongs to that business service

please let me know if you know the solution , small info will appreciated.

[rahulswami]

Hi @sunkarasath,

Yes, this is doable, but it needs a couple of pieces in place first.

Assignment Group (sys_user_group) has no native link to Business Service (cmdb_ci_service) out of the box, so before the filter can work, that relationship has to exist somewhere. Either a reference field on sys_user_group pointing to cmdb_ci_service, or a link through the CMDB relationship table (cmdb_rel_ci), or a related list already tying groups to services in your instance.

Once that link exists, set it up in two parts.

Part 1, connect the fields in the data model. Open the dictionary entry for assignment_group on the Incident table and set its "Dependent field" attribute to business_service. Then add a reference qualifier on that field. If the link is a direct field on sys_user_group, a simple qualifier works, something like business_service=javascript:current.business_service. If the link lives in the CMDB relationship table instead, use a script include that takes the business_service value and returns matching group sys_ids as an advanced reference qualifier.

Part 2, build the two interactive filters on the dashboard. Open the dashboard in edit mode, click the interactive filter icon, and add a filter on the Incident table for Business Service. Add a second filter on the Incident table for Assignment Group. Because assignment_group already has its dependent field and reference qualifier configured from Part 1, the Assignment Group filter will automatically show only the groups tied to whatever Business Service is currently selected, the same way it narrows on a form.

The main thing to remember is that interactive filters on reference fields inherit the field's own dependent field and reference qualifier setup. If that part isn't configured correctly, no amount of dashboard configuration will make the second filter behave as dependent.