dpazos-infragistics
commented
1 month ago The issue happens because null and empty are grouped together in dashboard filters, but when categorization is added to a bar chart, empty string and null values end up as separate categories. This causes it that when you click the bar for null values and try to navigate to the child dashboard, the value used to perform the link is just "\<null>", but the dashboard filter in the child dashboard only has "\<null or empty>" which of course, doesn't match.
Here I'm attaching two test dashboards that reproduce the scenario. The dashboards depend on a SQL Server DS with ID "msSqlId" and a DSI with ID "msSqlCustQueryDsItemId" with the following custom query: "SELECT * FROM (VALUES (1, 'Yes'), (2, 'No'), (3, null)) a(SomeID, Answer)"
Internally tracked as AB#32943.
PVillarmarzo
SDK Version
1.6.7
Client Framework
HTML/JavaScript
Server Platform
ASP.NET
Operating System
Windows
Description
This is confirmed by Diego and he likely has better working examples. If you have a parent dashboard with a Column viz and that column viz is categorized and one of the values in a category is null and you create a link to another dashboard that has a filter for the value being charted in the column viz, then the column viz doesn't map
<null>to<null or empty>. This results in the linked dashboard's filter getting set to<null>which is invalid and results in no data being presented on the linked dashboard.