# \[BUG-13224 13940\] Booleans displaying as True for json table data **URL:** \ **Category:** Ignition Early Access\ **Created:** [March 11, 2019, 9:02pm UTC](https://forum.inductiveautomation.com/t/bug-13224-13940-booleans-displaying-as-true-for-json-table-data/23229 "2019-03-11T21:02:03Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![SMcIntosh](https://avatars.discourse-cdn.com/v4/letter/s/a6a055/32.png) [@SMcIntosh](https://forum.inductiveautomation.com/u/SMcIntosh)\ **Post date:** [March 11, 2019, 9:02pm UTC](https://forum.inductiveautomation.com/t/bug-13224-13940-booleans-displaying-as-true-for-json-table-data/23229/1 "2019-03-11T21:02:03Z")
I am having some trouble with table booleans. They display as True in Perspective tables, regardless of whether the value is actually True or False. This seems to be happening in tables with a json formatted data parameter - the checkboxes/toggles display correctly if the table data is a dataset. In the below table, I have selected that all columns render as booleans with a checkbox style. The same problem also occurs with toggles. ![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/e/e476f05107b922bfd8dd1bd6d2964f0a0b7b1de9.png) ---
**Author:** ![SMcIntosh](https://avatars.discourse-cdn.com/v4/letter/s/a6a055/32.png) [@SMcIntosh](https://forum.inductiveautomation.com/u/SMcIntosh)\ **Post date:** [March 19, 2019, 9:17pm UTC](https://forum.inductiveautomation.com/t/bug-13224-13940-booleans-displaying-as-true-for-json-table-data/23229/2 "2019-03-19T21:17:11Z")
To add a bit more detail: the display works if the columns are something that may be interpreted as a boolean (eg. 0/1), but if the values are actually of boolean type it doesn’t work. When I bind the data to a named query selecting bit values, those bits are automatically converted to true/false if the return format is json - which I think makes sense, but it means I can’t directly bind my query to the table data if I want it in json format. Is anyone else encountering this? I’ve found I can reproduce it as of 8.0.0-beta0 (b2019031902). ---
**Author:** ![osolorzano](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/osolorzano/32/6432_2.png) [@osolorzano](https://forum.inductiveautomation.com/u/osolorzano)\ **Post date:** [March 19, 2019, 10:20pm UTC](https://forum.inductiveautomation.com/t/bug-13224-13940-booleans-displaying-as-true-for-json-table-data/23229/3 "2019-03-19T22:20:39Z")
I was able to reproduce with your explanation. I’ll get an internal ticket written up for this. Thanks for finding that! ---
**Author:** ![awalker](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/awalker/32/6874_2.png) [@awalker](https://forum.inductiveautomation.com/u/awalker)\ **Post date:** [April 26, 2019, 4:53pm UTC](https://forum.inductiveautomation.com/t/bug-13224-13940-booleans-displaying-as-true-for-json-table-data/23229/4 "2019-04-26T16:53:01Z")
This issue was fixed in the nightly 8.0.2 build that was uploaded today (4/26). ---
**Author:** ![nburt](https://avatars.discourse-cdn.com/v4/letter/n/2bfe46/32.png) [@nburt](https://forum.inductiveautomation.com/u/nburt)\ **Post date:** [June 18, 2019, 8:20pm UTC](https://forum.inductiveautomation.com/t/bug-13224-13940-booleans-displaying-as-true-for-json-table-data/23229/5 "2019-06-18T20:20:00Z")
I am running the 8.0.2 official build (b2019060511) and booleans are displaying correctly in tables when the data is json formatted, however, now booleans are not behaving properly when the data is a dataset. The incorrect behavior is the same as before- the booleans are always displaying as true. ---
**Author:** ![osolorzano](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/osolorzano/32/6432_2.png) [@osolorzano](https://forum.inductiveautomation.com/u/osolorzano)\ **Post date:** [June 18, 2019, 8:26pm UTC](https://forum.inductiveautomation.com/t/bug-13224-13940-booleans-displaying-as-true-for-json-table-data/23229/6 "2019-06-18T20:26:05Z")
Yes, this was found after 8.0.2 released. It is currently fixed in the 8.0.3 nightly and will be fixed as part of that release. ---
**Author:** ![robynbirch18](https://avatars.discourse-cdn.com/v4/letter/r/ce73a5/32.png) [@robynbirch18](https://forum.inductiveautomation.com/u/robynbirch18)\ **Post date:** [August 7, 2019, 6:48pm UTC](https://forum.inductiveautomation.com/t/bug-13224-13940-booleans-displaying-as-true-for-json-table-data/23229/7 "2019-08-07T18:48:10Z")
Somewhat related to this issue. I am using a data set that has an editable column that is preset to zeroes. When I go to edit the column in run time, the cell type changes to boolean an does not let me edit. The same goes for a value of 1, but all other initially set numerical values allow me to edit perfectly.