# Named Query Binding in Time Series Chart, Perspective

**URL:** <https://forum.inductiveautomation.com/t/named-query-binding-in-time-series-chart-perspective/44201>\
**Category:** Ignition\
**Tags:** ignition80\
**Created:** [March 7, 2021, 8:17pm UTC](https://forum.inductiveautomation.com/t/named-query-binding-in-time-series-chart-perspective/44201 "2021-03-07T20:17:13Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![sbeauregard66](https://avatars.discourse-cdn.com/v4/letter/s/ecd19e/32.png) [@sbeauregard66](https://forum.inductiveautomation.com/u/sbeauregard66)\
**Post date:** [March 7, 2021, 8:17pm UTC](https://forum.inductiveautomation.com/t/named-query-binding-in-time-series-chart-perspective/44201/1 "2021-03-07T20:17:13Z")

</div>

I’m beyond frustrated trying to bind a named query to a time series chart. I’ve read all the forums, followed all recommendations.

I run our system at work but are in the process of upgrading from 7.9 to 8.1 and it will be a few more weeks before transition is complete and haven’t had time to play with Perspective yet, so I decided to install Maker at home and connect to my home weather station and try to get a head start on Perspective.  
So that being said this isn’t my first rodeo, but it certainly feels like it.

I setup a very simple named query with no parameters and it tests just fine, displays fine in a table but no matter what I do I cannot get it to work in any chart, specifically time series.

- date first
- Order Asc

Just says component error with no errors in upper right corner. Tried setting the binding to Json and all that does is show 85000+ errors in right upper corner of chart props.

I’ve just upgraded to the most recent version and made no difference. **8.1.3 (b2021030309)**

Here are some screen shots of queries, component bonding etc.

 ![Binding](https://us1.discourse-cdn.com/inductiveautomation/original/3X/7/1/711fb688b6aa45ead62b5847f3f0d1e837af5138.png) ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/9/a/9a8e9c109c89164dcda70f9b3bd9176910612331.png)

The DB is MySQL

Thanks in advance

---

<div class="post-metadata">

**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\
**Post date:** [March 7, 2021, 8:29pm UTC](https://forum.inductiveautomation.com/t/named-query-binding-in-time-series-chart-perspective/44201/2 "2021-03-07T20:29:48Z")

</div>

What is the column type of the t\_stamp column in your dataset?

---

<div class="post-metadata">

**Author:** ![sbeauregard66](https://avatars.discourse-cdn.com/v4/letter/s/ecd19e/32.png) [@sbeauregard66](https://forum.inductiveautomation.com/u/sbeauregard66)\
**Post date:** [March 7, 2021, 8:41pm UTC](https://forum.inductiveautomation.com/t/named-query-binding-in-time-series-chart-perspective/44201/3 "2021-03-07T20:41:00Z")

</div>

It appears as it is Text (MySQL)

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

Here is our work (SQL Server)  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/0/0/00db5b6d518a3eaba5fe88005004ca69384260f7.png)

Both use the exact same transaction group settings. Is this a MySQL thing. I’ve never used MySQL until I set this up on my home computer?

---

<div class="post-metadata">

**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\
**Post date:** [March 7, 2021, 8:42pm UTC](https://forum.inductiveautomation.com/t/named-query-binding-in-time-series-chart-perspective/44201/4 "2021-03-07T20:42:12Z")

</div>

I don’t know why your column type is Text but that’s why your chart isn’t working. It needs to be a Date or numeric type.

---

<div class="post-metadata">

**Author:** ![sbeauregard66](https://avatars.discourse-cdn.com/v4/letter/s/ecd19e/32.png) [@sbeauregard66](https://forum.inductiveautomation.com/u/sbeauregard66)\
**Post date:** [March 7, 2021, 8:52pm UTC](https://forum.inductiveautomation.com/t/named-query-binding-in-time-series-chart-perspective/44201/5 "2021-03-07T20:52:56Z")

</div>

Yes I just changed the type using the MySQL Workbench and it is now working. Didn’t even think to check that. These tables were actually imported from a MSSQL table using .csv files.  
I will be checking all my other imported tables.

Thanks.