How do you create an interactive filter to work on CI Relationship table from a choice field?

[Robert Campbell]

I have a report on a dashboard that displays a score of the infrastructure related to services. We have a choice field called service team that is on the cmdb_ci table as well as all of the cmdb_ci_service tables.  The values on the service tables are greater than the limited amount on the cmdb_ci table.  When I create the filter it only shows the limited values from the cmdb_ci table, not those from the cmdb_ci_service table even though those are the cis that in the results.

[ersureshbe · Accepted solution]

Hi, create a db view and merge 2 tables. create the reports and dashboards with the help of db view.

[Robert Campbell]

The issue isn't the reports or dashboards, they display the data fine.  The issue is the interactive filter (choice) that needs to have the values of the tables cmdb_ci_service and u_cmdb_ci_business_application which is an extension of cmdb_ci_service.  The problem is the cmdb_ci table doesn't have all the values in sys_choice element that cmdb_ci_service does. 

This is the issue for all choice fields that have different choices than that on the top level table. 

[Maik Skoddow]

Hi

no direct answer but you could implement your own interactive filter to meet the requirement: https://www.servicenow.com/community/platform-analytics-articles/dashboards-approaches-for-interacti... 

Maik