# Perspective client not showing table data **URL:** \ **Category:** Ignition\ **Tags:** perspective\ **Created:** [February 17, 2023, 9:05pm UTC](https://forum.inductiveautomation.com/t/perspective-client-not-showing-table-data/70031 "2023-02-17T21:05:13Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![Ly17](https://avatars.discourse-cdn.com/v4/letter/l/c57346/32.png) [@Ly17](https://forum.inductiveautomation.com/u/Ly17)\ **Post date:** [February 17, 2023, 9:05pm UTC](https://forum.inductiveautomation.com/t/perspective-client-not-showing-table-data/70031/1 "2023-02-17T21:05:14Z")
I have a perspective table with a named query binding that returns data which I can see in the designer but when I run the client, the table doesn't show any data. What's causing this? Tables with manually entered data seems to work just fine. Thanks, ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [February 17, 2023, 9:38pm UTC](https://forum.inductiveautomation.com/t/perspective-client-not-showing-table-data/70031/2 "2023-02-17T21:38:04Z")
Does your client have permission to run the named query? (Named queries have their own security configuration.) ---
**Author:** ![Ly17](https://avatars.discourse-cdn.com/v4/letter/l/c57346/32.png) [@Ly17](https://forum.inductiveautomation.com/u/Ly17)\ **Post date:** [February 17, 2023, 9:55pm UTC](https://forum.inductiveautomation.com/t/perspective-client-not-showing-table-data/70031/3 "2023-02-17T21:55:58Z")
How do I check if my client has permission? ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [February 17, 2023, 10:04pm UTC](https://forum.inductiveautomation.com/t/perspective-client-not-showing-table-data/70031/4 "2023-02-17T22:04:32Z")
Compare the security levels you configured in the project against the security levels you configured on the named query. And then check that your user has that security level (or one of them, depending on how you set it up). ---
**Author:** ![Ly17](https://avatars.discourse-cdn.com/v4/letter/l/c57346/32.png) [@Ly17](https://forum.inductiveautomation.com/u/Ly17)\ **Post date:** [February 17, 2023, 10:44pm UTC](https://forum.inductiveautomation.com/t/perspective-client-not-showing-table-data/70031/5 "2023-02-17T22:44:20Z")
Named query is set to Any and project is Public so should be unrestricted. ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [February 17, 2023, 10:45pm UTC](https://forum.inductiveautomation.com/t/perspective-client-not-showing-table-data/70031/6 "2023-02-17T22:45:15Z")
Then you will need to look in your gateway logs for errors at about the time you expect data to show up. ---
**Author:** ![Ly17](https://avatars.discourse-cdn.com/v4/letter/l/c57346/32.png) [@Ly17](https://forum.inductiveautomation.com/u/Ly17)\ **Post date:** [February 17, 2023, 11:04pm UTC](https://forum.inductiveautomation.com/t/perspective-client-not-showing-table-data/70031/7 "2023-02-17T23:04:24Z")
I have named query binding to LED displays and those work just fine. I don't see any errors in the log. ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [February 17, 2023, 11:06pm UTC](https://forum.inductiveautomation.com/t/perspective-client-not-showing-table-data/70031/8 "2023-02-17T23:06:06Z")
If some query bindings work and others don't, you need to study the differences. You'll need to share a great deal more detail for us to be much more help. ---
**Author:** ![Ly17](https://avatars.discourse-cdn.com/v4/letter/l/c57346/32.png) [@Ly17](https://forum.inductiveautomation.com/u/Ly17)\ **Post date:** [February 17, 2023, 11:59pm UTC](https://forum.inductiveautomation.com/t/perspective-client-not-showing-table-data/70031/9 "2023-02-17T23:59:04Z")
So, I've tried 2 named queries. One with parameters and one without. The one with parameters didn't work in a sense that it didn't show any data in the perspective client but did show correctly in the designer. The one without parameters worked and did show data in the perspective client. Any thoughts on why parameters wouldn't work in this instance? ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [February 18, 2023, 12:13am UTC](https://forum.inductiveautomation.com/t/perspective-client-not-showing-table-data/70031/10 "2023-02-18T00:13:26Z")
Are your parameters referencing session properties that behave differently in a real client? (The designer is a very limited test environment. You may be making assumptions about what is expected to work there versus a client.) A screenshot of your failing query binding would likely help. Consider adding labels to your view that display the content of the bindings you are trying to use on the query. ---
**Author:** ![Ly17](https://avatars.discourse-cdn.com/v4/letter/l/c57346/32.png) [@Ly17](https://forum.inductiveautomation.com/u/Ly17)\ **Post date:** [February 18, 2023, 1:06am UTC](https://forum.inductiveautomation.com/t/perspective-client-not-showing-table-data/70031/11 "2023-02-18T01:06:57Z")
My parameters are referencing UDT tags (one memory tag and one expression tag). Here is a screenshot of the named query that didn't work. ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/7/1/717068e89eb5544e8f10b733df30b1a14e552fad.png) ---
**Author:** ![msitson](https://avatars.discourse-cdn.com/v4/letter/m/3ab097/32.png) [@msitson](https://forum.inductiveautomation.com/u/msitson)\ **Post date:** [April 9, 2024, 4:52pm UTC](https://forum.inductiveautomation.com/t/perspective-client-not-showing-table-data/70031/12 "2024-04-09T16:52:04Z")
Was this issue ever resolved? I am running into a similar problem. However, my parameters do not use UDT tags. I use a custom prop that holds the current date and the other is a string value.