# Dashboard published empty/null field causes other related query not working properly **URL:** \ **Category:** Epicor ERP 10\ **Created:** [December 12, 2017, 3:47am UTC](https://www.epiusers.help/t/dashboard-published-empty-null-field-causes-other-related-query-not-working-properly/41775 "2017-12-12T03:47:12Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![ctbeh](https://www.epiusers.help/letter_avatar_proxy/v4/letter/c/9f8e36/32.png) [@ctbeh](https://www.epiusers.help/u/ctbeh)\ **Post date:** [December 12, 2017, 3:47am UTC](https://www.epiusers.help/t/dashboard-published-empty-null-field-causes-other-related-query-not-working-properly/41775/1 "2017-12-12T03:47:12Z")
Hi There, I have a dashboard with 2 queries in it. First query is to show the summary while the second query is to show the details of the selected line in the summary query. Unfortunately, the publish field from 1 of the lines in summary query is either empty or null has caused the second query to fetch incorrect data. By checking at the SQL Server Management Studio, the query does return result if the publish field is ‘’ (empty), but does not return any result if the publish field is null. Please advise what should I do in order to show the details in the dashboard for field which is empty or null. Thanks in advance. Regards, Beh ---
**Author:** ![knash](https://www.epiusers.help/user_avatar/www.epiusers.help/knash/32/74179_2.png) [@knash](https://www.epiusers.help/u/knash)\ **Post date:** [December 12, 2017, 4:26pm UTC](https://www.epiusers.help/t/dashboard-published-empty-null-field-causes-other-related-query-not-working-properly/41775/2 "2017-12-12T16:26:25Z")
Just to make sure you are looking at the properties of the dashboard query, not the dashboard grid properties. Your first dashboard query you publish like the following. ![Capture](https://epiusers.help/uploads/default/original/2X/6/6fccfa85d9cf6bb1e63d0c8161758e43970c4c0c.JPG) The second dashboard query you filter on the fields. ![Capture2](https://epiusers.help/uploads/default/original/2X/e/e1933eee46e2dfb57a4c5e9f5195d2bda619c008.JPG) ---
**Author:** ![ctbeh](https://www.epiusers.help/letter_avatar_proxy/v4/letter/c/9f8e36/32.png) [@ctbeh](https://www.epiusers.help/u/ctbeh)\ **Post date:** [December 13, 2017, 10:31am UTC](https://www.epiusers.help/t/dashboard-published-empty-null-field-causes-other-related-query-not-working-properly/41775/3 "2017-12-13T10:31:33Z")
Hi Ken Nash, Yes. My dashboard did publish and subscribe as per your examples. Just that my first dashboard is publishing an UD field which is null-able. When the published field is Null, the second query won’t show anything. ![NonEmptyField](https://epiusers.help/uploads/default/original/2X/9/9241592492dfec5b4c8e5364cfae47da3e01ad7f.PNG) Thanks & Regards, Beh ---
**Author:** ![ctbeh](https://www.epiusers.help/letter_avatar_proxy/v4/letter/c/9f8e36/32.png) [@ctbeh](https://www.epiusers.help/u/ctbeh)\ **Post date:** [December 13, 2017, 10:32am UTC](https://www.epiusers.help/t/dashboard-published-empty-null-field-causes-other-related-query-not-working-properly/41775/4 "2017-12-13T10:32:12Z")
Here is the second snapshot ![EmptyField](https://epiusers.help/uploads/default/original/2X/9/9fa28adfc89bdec6344e71a28058c06bba95cc7a.PNG) ---
**Author:** ![knash](https://www.epiusers.help/user_avatar/www.epiusers.help/knash/32/74179_2.png) [@knash](https://www.epiusers.help/u/knash)\ **Post date:** [December 13, 2017, 4:46pm UTC](https://www.epiusers.help/t/dashboard-published-empty-null-field-causes-other-related-query-not-working-properly/41775/5 "2017-12-13T16:46:43Z")
query 1 returns null for UD field because there is no record, I am guessing you are using a left join. query 2 the UD field is that the detail of the table with the UD field, I am guessing you are using a inner join or showing just one table. There is no null value summary then. That is why there are no records shown in the summary then. If what I am assuming is the case. ---
**Author:** ![ctbeh](https://www.epiusers.help/letter_avatar_proxy/v4/letter/c/9f8e36/32.png) [@ctbeh](https://www.epiusers.help/u/ctbeh)\ **Post date:** [December 14, 2017, 1:24am UTC](https://www.epiusers.help/t/dashboard-published-empty-null-field-causes-other-related-query-not-working-properly/41775/6 "2017-12-14T01:24:32Z")
Hi Ken Nash, Both queries are using inner join and individually query 2 able to show null value. Only when linking both query where query 2 rely on query 1 input, query 2 won’t show result if query 1 input is null or empty. Thanks & Regards, Beh ---
**Author:** ![knash](https://www.epiusers.help/user_avatar/www.epiusers.help/knash/32/74179_2.png) [@knash](https://www.epiusers.help/u/knash)\ **Post date:** [December 14, 2017, 3:01pm UTC](https://www.epiusers.help/t/dashboard-published-empty-null-field-causes-other-related-query-not-working-properly/41775/7 "2017-12-14T15:01:59Z")
can you post the queries? Thanks, ---
**Author:** ![ctbeh](https://www.epiusers.help/letter_avatar_proxy/v4/letter/c/9f8e36/32.png) [@ctbeh](https://www.epiusers.help/u/ctbeh)\ **Post date:** [December 15, 2017, 4:03am UTC](https://www.epiusers.help/t/dashboard-published-empty-null-field-causes-other-related-query-not-working-properly/41775/8 "2017-12-15T04:03:43Z")
Hi Ken, It’s OK. We manage to solve it. What we did is changing the published calculated TranDate to NVarChar, then the query 2 able to show the data. Thanks for helping. Thanks & Regards, Beh