# \[Question\] simple sql query into perspective table **URL:** \ **Category:** Ignition Early Access\ **Created:** [February 26, 2019, 3:22pm UTC](https://forum.inductiveautomation.com/t/question-simple-sql-query-into-perspective-table/22879 "2019-02-26T15:22:06Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![jhottell](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jhottell/32/6472_2.png) [@jhottell](https://forum.inductiveautomation.com/u/jhottell)\ **Post date:** [February 26, 2019, 3:22pm UTC](https://forum.inductiveautomation.com/t/question-simple-sql-query-into-perspective-table/22879/1 "2019-02-26T15:22:06Z")
I don’t understand how to display data from a SQL query in a perspective table. I have a named query that works great, just plop it into the Vision power table and you have a few rows and columns in about 5 seconds. How do we display data in the Perspective table? It seems bewilderingly complex or I am missing something? I see from the forums a dataset or array, so should I transform the data into an array somehow? An example or documentation would be greatly appreciated. Thanks! ---
**Author:** ![cmallonee](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/cmallonee/32/6416_2.png) [@cmallonee](https://forum.inductiveautomation.com/u/cmallonee)\ **Post date:** [February 26, 2019, 3:34pm UTC](https://forum.inductiveautomation.com/t/question-simple-sql-query-into-perspective-table/22879/2 "2019-02-26T15:34:46Z")
If you have a working Named Query, all you should need to do is bind the Table.props.data field with a Query Binding, and select the Named Query by specifying the Path of the Query (or using the magnifying glass icon to search for it). ![15%20AM](https://us1.discourse-cdn.com/inductiveautomation/original/2X/c/c0bbe429e1688012159add13eab37decefeb55d7.png) ---
**Author:** ![jhottell](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jhottell/32/6472_2.png) [@jhottell](https://forum.inductiveautomation.com/u/jhottell)\ **Post date:** [February 26, 2019, 3:40pm UTC](https://forum.inductiveautomation.com/t/question-simple-sql-query-into-perspective-table/22879/3 "2019-02-26T15:40:47Z")
Thank you sir, you helped me figure it out, I didn’t have quotes around the static named query filter. It just said “Error\_Configuration” and I didn’t see anything in the console to help me with my ID10T error. ![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/c/cc8a2e9ece64442465b7f448e73d75b9ab4d8673.png) ---
**Author:** ![jianping.li](https://avatars.discourse-cdn.com/v4/letter/j/c89c15/32.png) [@jianping.li](https://forum.inductiveautomation.com/u/jianping.li)\ **Post date:** [April 29, 2019, 3:58am UTC](https://forum.inductiveautomation.com/t/question-simple-sql-query-into-perspective-table/22879/4 "2019-04-29T03:58:36Z")
I have met the same question, has it solved yet? ---
**Author:** ![KathyApplebaum](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kathyapplebaum/32/7261_2.png) [@KathyApplebaum](https://forum.inductiveautomation.com/u/KathyApplebaum)\ **Post date:** [April 29, 2019, 3:43pm UTC](https://forum.inductiveautomation.com/t/question-simple-sql-query-into-perspective-table/22879/5 "2019-04-29T15:43:57Z")
Did you try the solution above? If so, what happened? We need some more details in order to be able to help you with this. ---
**Author:** ![jhottell](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jhottell/32/6472_2.png) [@jhottell](https://forum.inductiveautomation.com/u/jhottell)\ **Post date:** [April 29, 2019, 7:17pm UTC](https://forum.inductiveautomation.com/t/question-simple-sql-query-into-perspective-table/22879/6 "2019-04-29T19:17:26Z")
If the named query “Value” is a static string, put quotes around it and it works. ---
**Author:** ![aburgess](https://avatars.discourse-cdn.com/v4/letter/a/3ec8ea/32.png) [@aburgess](https://forum.inductiveautomation.com/u/aburgess)\ **Post date:** [October 21, 2019, 10:06pm UTC](https://forum.inductiveautomation.com/t/question-simple-sql-query-into-perspective-table/22879/7 "2019-10-21T22:06:52Z")
@KathyApplebaum, I just ran into this issue myself. It would appear that the Named Query binding in Perspective is not handling strings properly. In order to avoid getting the error listed below and null returned from the binding, single quotes must manually be added to the strings that are being passed as Named Query parameters. This is using “Value” type parameters with their datatype set to string. I am running 8.0.5 Stable. It is worth noting that within the Named Query “Testing” tab, the query runs fine without the single quotes added to the parameter values. I haven’t noticed this issue in Vision or Reporting. Without single quotes: ![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/f/f5c71f3449a84b180efa36e5d67c14f7b4ec22a0.png) With single quotes: ![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/b/ba64d0de0bb855238dab35e20397123313b6437f.png) Error text: RuntimeException: Syntax Error on Token: ‘End of Expression’ (Line 0 , Char 0) ---
**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:** [October 21, 2019, 10:29pm UTC](https://forum.inductiveautomation.com/t/question-simple-sql-query-into-perspective-table/22879/8 "2019-10-21T22:29:01Z")
The reason you need quotes for literal string parameters in the named query binding is because the inputs there are Expression editors which you can tell by the little `fx` symbols on the right. Expressions require that literal strings be in quotes just like when doing an expression binding. ---
**Author:** ![aburgess](https://avatars.discourse-cdn.com/v4/letter/a/3ec8ea/32.png) [@aburgess](https://forum.inductiveautomation.com/u/aburgess)\ **Post date:** [October 21, 2019, 10:44pm UTC](https://forum.inductiveautomation.com/t/question-simple-sql-query-into-perspective-table/22879/9 "2019-10-21T22:44:38Z")
Ah, ok. That makes a lot more sense. 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:** [July 29, 2025, 12:50pm UTC](https://forum.inductiveautomation.com/t/question-simple-sql-query-into-perspective-table/22879/10 "2025-07-29T12:50:28Z")
Split this topic on July 29, 2025, 12:50pm UTC A post was merged into an existing topic: [Table Binding Issue – Query Returns Data but Nothing Displays in Perspective Table](https://forum.inductiveautomation.com/t/table-binding-issue-query-returns-data-but-nothing-displays-in-perspective-table/109052/2)