Cascade interactive filter

[harshw]

Hi All,

I have created a report on Vulnerable item table. Now there is a need to create interactive filter which will list CTO's (some users) . Vulnerable item contains "assignment group" field and we have a different mapping table(VR Domain Mapping) where CTO's are mapped to Assignment group . So i have created a cascading interactive filter and on 1st level i have done mapping from user table to VR domain mapping -CTO field .

On 2nd level i have done mapping of assignment group of VR Domain mapping to assignment group of Vulnerable item table(records which are displayed on dashboard).

Now interactive filter works properly when both level filters are selected . But if we select first level and on second level if we select ALL then even 1st level filter seems to not work . The "All" selected on 2nd level is not applying 1st level filter and shows all the records irrespective of 1st filter .

@isaak_papagiann @ChristineP  @Chuck Tomasi 

[isaak_papagiann · Accepted solution]

Hi,

Your screenshots show that CC1 filters the "domain mapping" table and CC2 the "Vulnerable Item" table. Based on your description, I believe you expect CC1 to filter the "Vulnerable Item" as well, so I suggest you add a Target table record for the Vulnerable Item table pointing to the field that links these tables.

To help yourself, please use the debug filter widget: https://docs.servicenow.com/bundle/tokyo-now-intelligence/page/use/dashboards/concept/c_DebugPublish...

Isaak