# Perspective Table Not Displaying All Data In Query

**URL:** <https://forum.inductiveautomation.com/t/perspective-table-not-displaying-all-data-in-query/41429>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [December 11, 2020, 5:31pm UTC](https://forum.inductiveautomation.com/t/perspective-table-not-displaying-all-data-in-query/41429 "2020-12-11T17:31:00Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![jon.smith](https://avatars.discourse-cdn.com/v4/letter/j/c2a13f/32.png) [@jon.smith](https://forum.inductiveautomation.com/u/jon.smith)\
**Post date:** [December 11, 2020, 5:31pm UTC](https://forum.inductiveautomation.com/t/perspective-table-not-displaying-all-data-in-query/41429/1 "2020-12-11T17:31:00Z")

</div>

I’m having an issue, Ignition Version: **8.1.0 (b2020110211)**, with a sql query working correctly in testing but when i apply to a table in perspective it only pulls back one row instead of all the rows I requested. Anyone else seeing the same problem?

Query:

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

Test Results:

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

Perspective Results:

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

---

<div class="post-metadata">

**Author:** ![suryawanshinr2011](https://avatars.discourse-cdn.com/v4/letter/s/eb8c5e/32.png) [@suryawanshinr2011](https://forum.inductiveautomation.com/u/suryawanshinr2011)\
**Post date:** [April 14, 2022, 6:19am UTC](https://forum.inductiveautomation.com/t/perspective-table-not-displaying-all-data-in-query/41429/2 "2022-04-14T06:19:26Z")

</div>

I am also having same issue my gateway version is 8.1.15, database table having 4 rows and perspective table having 3 rows, why one row eliminating by perspective table that reason I am searching  
i tried polling , also changed data type , any one having solutions

---

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [April 14, 2022, 8:12am UTC](https://forum.inductiveautomation.com/t/perspective-table-not-displaying-all-data-in-query/41429/3 "2022-04-14T08:12:55Z")

</div>

> [@suryawanshinr2011](#):
>
> any one having solution

You would need to provide a lot more information if you are hoping for help on this.