Reference Filters on CMDB_CI and report on CMDB_REL_CI

[dgarod]

Our report sits on CMDB_REL_CI table and the objective is to be able to show Parent Business Services and related Child CIs. We have put this report onto a Dashboard and needed to apply two reference filters: Parent and Child.

Both filters have a Reference table as CMDB_CI and Interactive Filter Reference for Child filter is pointing to cmdb_rel_ci / child and for the Parent it  is pointing to cmdb_rel_ci / parent. See second screenshot.

Both filter do have the valid values in them, however the problem is that the Child filter works as expected, but the parent does not bring any data in the report when a specific Business CI is selected.

Can you help please?

Thanks. 

Second screenshot

[Alec Hanson]

It would be worth you adding in the Debug widget so that you can see what the Interactive Filters are doing. If you do that and post the output that would help.

[dgarod]

Alec, I'm quite new to ServiceNow. How do I add the Debug widget to the dashbaord?

Thanks. 

[Alec Hanson]

It is a special 'Widget' for a dashboard that shows you the 'commands' used to do the filtering.

All you need to do is to add a new Widget to the dashboard, select the "Interactive Filters" section and then the "{Debug}" section.

Keep going until you can add the widget. That will display on the dashboard.

Then just perform the search you want that is not working and the output is displayed in the Debug Widget and will help to show what the interactive filters are doing.