Perspective Table Not Displaying All Data In Query

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?


Test Results:

Perspective Results:

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

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