Drill down with interactive filter - breadcrumbs are odd and filters are not valid

Paul St_ Martin
Kilo Contributor

‎04-04-2019 06:30 AM

I need help regarding odd results when drilling into the data on charts with an interactive filter applied.  The breadcrumbs look odd, the filters have parens in them, and when I click Run I get no data returned.

Here's an example. I have one interactive filter set, with one value. When I drill in, the fist breadcrumb shows my selection "Product Line in (HouseCalls)", then there are several 'bad' Product Line breadcrumbs; the filters show Product Line 3 times, and those filters have parens in the text (also note that "IN" is not a typical option - should be "is one of"):

find_real_file.png

When I click Run, the breadcrumbs now show empty IN clauses repeated 3 times, and it returns no data due to the bad filters:

find_real_file.png

This occurs for various interactive filters; it occurs regardless of the "Apply to both database views and tables" and "Apply to all tables in hierarchy" settings.  

I'm not sure when this started occurring, but perhaps with our 2/26/2019 upgrade to London.

This is similar to another post: https://community.servicenow.com/community?id=community_question&sys_id=e4b5bb1ddb543b84fece0b55ca96...

Might I need to change my interactive filters?  Is this a bug?

-Paul

Labels:
Preview file
53 KB
Preview file
42 KB
0 Helpfuls
  • 2,602 Views
12 REPLIES 12

Adam Stout
ServiceNow Employee
ServiceNow Employee

‎04-04-2019 10:52 AM

Can you include a screenshot of the interactive filter and the report?

0 Helpfuls

Paul St_ Martin
Kilo Contributor

‎04-04-2019 01:10 PM

Example interactive filter:

find_real_file.png

 

 

Example report:

find_real_file.png

 

Preview file
60 KB
Preview file
101 KB
0 Helpfuls

Adam Stout
ServiceNow Employee
ServiceNow Employee
In response to Paul St_ Martin

‎04-04-2019 03:41 PM

Do any of the mapped tables extend one another?  The view option is very useful but the hierarchy ends up biting more often than not when I enable it.  It is typically not needed (with some use cases where it is very useful).

Paul St_ Martin
Kilo Contributor

‎04-05-2019 08:16 AM

Thanks Adam.

The mapped tables do not extend one another.

I just confirmed that when I disable the "Apply to both database views and tables" and "Apply to all tables in hierarchy" options I get the same results. In addition, I removed the view from the mappings and got the same result. I then removed all mappings except the one table needed by the report - same result.

0 Helpfuls