# Power Table not displaying Integer

**URL:** <https://forum.inductiveautomation.com/t/power-table-not-displaying-integer/46912>\
**Category:** Ignition\
**Tags:** ignition78\
**Created:** [May 19, 2021, 8:35pm UTC](https://forum.inductiveautomation.com/t/power-table-not-displaying-integer/46912 "2021-05-19T20:35:30Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![dmiessner](https://avatars.discourse-cdn.com/v4/letter/d/77aa72/32.png) [@dmiessner](https://forum.inductiveautomation.com/u/dmiessner)\
**Post date:** [May 19, 2021, 8:35pm UTC](https://forum.inductiveautomation.com/t/power-table-not-displaying-integer/46912/1 "2021-05-19T20:35:30Z")

</div>

Hello, exactly as I described above, a Power Table of mine is not displaying 1 of the integers that I am selecting, and I cannot figure out why, since it selects and displays one of the other integers that I am selecting.

Query below:

```auto
SELECT
OrderID,
Project,
EE_Sub_Assembly,
ME_Sub_Assembly,
Qty,
Description,
MFG_Part_Number,
Manufacturer,
Device_ID,
Allow_Sub_YN,
Pref_Vendor,
Req_Delivery_date,
Quote_Number
Lead_Time,
Order_By,
Req_Spare_Qty
FROM BOM_Purchasing
where project = '{Root Container.Project Selector.selectedLabel}'

```

And Power Table in Question:

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/0/c/0cecf44d2f214f1e9799f77ecdd60a4bd9bb6e76.png)

And an image of the database manager showing that there is in fact something in Lead Time:

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/7/e/7e8698b234d5bc9dea588c5ff57d3b3998160995.png)

I have absolutely no idea what may be causing this. Any insight at all would be very appreciated. Thank you!

---

<div class="post-metadata">

**Author:** ![dmiessner](https://avatars.discourse-cdn.com/v4/letter/d/77aa72/32.png) [@dmiessner](https://forum.inductiveautomation.com/u/dmiessner)\
**Post date:** [May 19, 2021, 8:52pm UTC](https://forum.inductiveautomation.com/t/power-table-not-displaying-integer/46912/2 "2021-05-19T20:52:27Z")

</div>

I know why.

```auto
Req_Delivery_date,
Quote_Number
Lead_Time,

```

Missing a comma 🙂