Drill down with interactive filter - breadcrumbs are odd and filters are not valid
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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"):
When I click Run, the breadcrumbs now show empty IN clauses repeated 3 times, and it returns no data due to the bad filters:
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-04-2019 10:52 AM
Can you include a screenshot of the interactive filter and the report?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-04-2019 01:10 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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).
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.