# Perspective Reporting DataKey True/False for Nested Query

**URL:** <https://forum.inductiveautomation.com/t/perspective-reporting-datakey-true-false-for-nested-query/81313>\
**Category:** General Discussion\
**Tags:** perspective\
**Created:** [November 1, 2023, 3:55pm UTC](https://forum.inductiveautomation.com/t/perspective-reporting-datakey-true-false-for-nested-query/81313 "2023-11-01T15:55:40Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Eagel007](https://avatars.discourse-cdn.com/v4/letter/e/7bcc69/32.png) [@Eagel007](https://forum.inductiveautomation.com/u/Eagel007)\
**Post date:** [November 1, 2023, 3:55pm UTC](https://forum.inductiveautomation.com/t/perspective-reporting-datakey-true-false-for-nested-query/81313/1 "2023-11-01T15:55:40Z")

</div>

Hi,

I am currently using Visible property with Dynamic Data Key. I need to set it to false if nested query Value is Null.  
I have 3 level nested queries,

1. Location  
1.1 Data  
1.1.1 Details

The visible property I am trying to use is in Details table. If Type Column value. in Data Table is null then False. So I can show 1.1.1 Table only on specific instances where data.Type column value is not null.  
I am currently using, **Location.Data.Type!=" "?"True"**.

Its not working Can you please help with this? Thanks

---

<div class="post-metadata">

**Author:** ![KathyApplebaum](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kathyapplebaum/32/7261_2.png) [@KathyApplebaum](https://forum.inductiveautomation.com/u/KathyApplebaum)\
**Post date:** [November 3, 2023, 2:32pm UTC](https://forum.inductiveautomation.com/t/perspective-reporting-datakey-true-false-for-nested-query/81313/2 "2023-11-03T14:32:22Z")

</div>

It would probably help for you to read [ReportMill's document](https://www.reportmill.com/support/keychains.pdf) on Keychain Expressions first. (ReportMill is the reporting engine we use)

ReportMill will evaluate NULL values as false and non-NULL as true in keychains, so I suspect you can simplify your keychain. I don't fully understand your data and report setup, but it might be that `Type` is sufficient here.