# Using SQL Queries in charts (sparkline)

**URL:** <https://forum.inductiveautomation.com/t/using-sql-queries-in-charts-sparkline/23091>\
**Category:** Ignition\
**Created:** [March 6, 2019, 10:17am UTC](https://forum.inductiveautomation.com/t/using-sql-queries-in-charts-sparkline/23091 "2019-03-06T10:17:07Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![nminchin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nminchin/32/6911_2.png) [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\
**Post date:** [March 6, 2019, 10:17am UTC](https://forum.inductiveautomation.com/t/using-sql-queries-in-charts-sparkline/23091/1 "2019-03-06T10:17:07Z")

</div>

I’m trying to use an SQL query to populate the data in a sparkline chart, however I get the following error in the diagnostics viewer on the component: `data$CONFIG: Config Error`

My query is simply:

```auto
SELECT logged_on, baume_corr, temp_pv
FROM vwTankFermentLogData
WHERE ferment_id = {Root Container.FermentID}

```

The first column is the datetime (x axis), and the second two columns are data values (y axis).

How does the chart know what columns to use for what? The user manual doesn’t seem to offer much help here.

If it’s of any consequence, the date/time data type is datetime2(7).  
FYIW: I converted the datetime to unix datetime and this didn’t work either.

Thanks!

Nick

---

<div class="post-metadata">

**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:** [March 6, 2019, 11:29am UTC](https://forum.inductiveautomation.com/t/using-sql-queries-in-charts-sparkline/23091/2 "2019-03-06T11:29:29Z")

</div>

Try casting the datetime2 to just datetime.

---

<div class="post-metadata">

**Author:** ![Matrix\_Engineering](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/matrix_engineering/32/19781_2.png) [@Matrix\_Engineering](https://forum.inductiveautomation.com/u/Matrix_Engineering)\
**Post date:** [March 6, 2019, 12:24pm UTC](https://forum.inductiveautomation.com/t/using-sql-queries-in-charts-sparkline/23091/3 "2019-03-06T12:24:49Z")

</div>

Shouldn’t it be:

```auto
SELECT logged_on, baume_corr, temp_pv
FROM vwTankFermentLogData
WHERE ferment_id = '{Root Container.FermentID}'

```

?

---

<div class="post-metadata">

**Author:** ![nminchin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nminchin/32/6911_2.png) [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\
**Post date:** [March 6, 2019, 12:38pm UTC](https://forum.inductiveautomation.com/t/using-sql-queries-in-charts-sparkline/23091/4 "2019-03-06T12:38:06Z")

</div>

Nope, ferment id is an integer field so comparing to a string would most likely result in an error

---

<div class="post-metadata">

**Author:** ![nminchin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nminchin/32/6911_2.png) [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\
**Post date:** [March 6, 2019, 12:38pm UTC](https://forum.inductiveautomation.com/t/using-sql-queries-in-charts-sparkline/23091/5 "2019-03-06T12:38:42Z")

</div>

Thanks Phil, I’ll try this in the morning (11pm here).