# Error Illegal type for X value: class java.lang.String (column 'horas')

**URL:** <https://forum.inductiveautomation.com/t/error-illegal-type-for-x-value-class-java-lang-string-column-horas/35884>\
**Category:** Ignition\
**Created:** [June 22, 2020, 6:06pm UTC](https://forum.inductiveautomation.com/t/error-illegal-type-for-x-value-class-java-lang-string-column-horas/35884 "2020-06-22T18:06:20Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![antonio.sanchez](https://avatars.discourse-cdn.com/v4/letter/a/a587f6/32.png) [@antonio.sanchez](https://forum.inductiveautomation.com/u/antonio.sanchez)\
**Post date:** [June 22, 2020, 6:06pm UTC](https://forum.inductiveautomation.com/t/error-illegal-type-for-x-value-class-java-lang-string-column-horas/35884/1 "2020-06-22T18:06:20Z")

</div>

Hello I have the next query

```auto
Illegal type for X value: class java.lang.String (column 'horas')

```

but return the next error

**IllegalArgumentException: Illegal type for X value: class java.lang.String (column ‘horas’)**

**Ignition v7.9.9 (b2018081621)**  
**Java: Oracle Corporation 1.8.0\_251**

in the Dataset is correct the information

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/c/c/cccc32a9aaeb34a3ffc8cfbb9605928526c0d7fd.png)

---

<div class="post-metadata">

**Author:** ![kaushik.shah](https://avatars.discourse-cdn.com/v4/letter/k/34f0e0/32.png) [@kaushik.shah](https://forum.inductiveautomation.com/u/kaushik.shah)\
**Post date:** [June 22, 2020, 6:32pm UTC](https://forum.inductiveautomation.com/t/error-illegal-type-for-x-value-class-java-lang-string-column-horas/35884/2 "2020-06-22T18:32:21Z")

</div>

> [@antonio.sanchez](#):
>
> in the Dataset is correct the information

Can you elaborate a little ? Is it trying to fetch the Info from Database ? If so, to a table ? What are you exactly trying to do ?

Thanks

---

<div class="post-metadata">

**Author:** ![antonio.sanchez](https://avatars.discourse-cdn.com/v4/letter/a/a587f6/32.png) [@antonio.sanchez](https://forum.inductiveautomation.com/u/antonio.sanchez)\
**Post date:** [June 22, 2020, 6:59pm UTC](https://forum.inductiveautomation.com/t/error-illegal-type-for-x-value-class-java-lang-string-column-horas/35884/3 "2020-06-22T18:59:29Z")

</div>

yes, this is my query

```auto
SELECT CONVERT(VARCHAR, Fecha, 108),
SUM(CASE WHEN Linea = 'Linea_Disco' THEN Qty else 0 END) as 'Linea_Disco',
SUM(CASE WHEN Linea = 'Linea_Rim' THEN Qty else 0 END) as 'Linea_Rim',
SUM(CASE WHEN Linea = 'Linea_Assy' THEN Qty else 0 END) as 'Linea_Assy',
SUM(CASE WHEN Linea = 'Linea_ED' THEN Qty else 0 END) as 'Linea_ED',
SUM(CASE WHEN Linea = 'Linea_TC' THEN Qty else 0 END) as 'Linea_TC'
from HistoricoContador
where CONVERT (date,Fecha) = dateadd(day, -0,CAST(GETDATE() as DATE))
GROUP BY CONVERT(VARCHAR, Fecha, 108)
ORDER BY CONVERT(VARCHAR, Fecha, 108) ASC

```

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [June 22, 2020, 8:09pm UTC](https://forum.inductiveautomation.com/t/error-illegal-type-for-x-value-class-java-lang-string-column-horas/35884/4 "2020-06-22T20:09:48Z")

</div>

> [@antonio.sanchez](#):
>
> CONVERT(VARCHAR, Fecha, 108)

`CONVERT(VARCHAR, Fecha, 108)`  
`IllegalArgumentException: Illegal type for X value: class java.lang.String (column ‘horas’)`  
Your X-axis (`horas`) is an invalid type (String, because you converted it to `VARCHAR` in the query).

---

<div class="post-metadata">

**Author:** ![antonio.sanchez](https://avatars.discourse-cdn.com/v4/letter/a/a587f6/32.png) [@antonio.sanchez](https://forum.inductiveautomation.com/u/antonio.sanchez)\
**Post date:** [June 22, 2020, 8:57pm UTC](https://forum.inductiveautomation.com/t/error-illegal-type-for-x-value-class-java-lang-string-column-horas/35884/5 "2020-06-22T20:57:40Z")

</div>

ok, so what can I do to group myself by hours

---

<div class="post-metadata">

**Author:** ![kaushik.shah](https://avatars.discourse-cdn.com/v4/letter/k/34f0e0/32.png) [@kaushik.shah](https://forum.inductiveautomation.com/u/kaushik.shah)\
**Post date:** [June 22, 2020, 9:16pm UTC](https://forum.inductiveautomation.com/t/error-illegal-type-for-x-value-class-java-lang-string-column-horas/35884/6 "2020-06-22T21:16:09Z")

</div>

How about this query ?

```auto
SELECT CONVERT(Date, Fecha, 108) AS horas,
       SUM(CASE WHEN Linea = 'Linea_Disco' THEN Qty else 0 END) AS 'Linea_Disco',
       SUM(CASE WHEN Linea = 'Linea_Rim' THEN Qty else 0 END) AS 'Linea_Rim', 
       SUM(CASE WHEN Linea = 'Linea_Assy' THEN Qty else 0 END) AS 'Linea_Assy',
       SUM(CASE WHEN Linea = 'Linea_ED' THEN Qty else 0 END) AS 'Linea_ED',
       SUM(CASE WHEN Linea = 'Linea_TC' THEN Qty else 0 END) AS 'Linea_TC'
FROM HistoricoContador
WHERE Fecha >= DATEADD(day, -0, convert(date, GETDATE()))
GROUP BY CONVERT(VARCHAR, Fecha, 108)
ORDER BY Fecha

```

---

<div class="post-metadata">

**Author:** ![antonio.sanchez](https://avatars.discourse-cdn.com/v4/letter/a/a587f6/32.png) [@antonio.sanchez](https://forum.inductiveautomation.com/u/antonio.sanchez)\
**Post date:** [June 22, 2020, 9:41pm UTC](https://forum.inductiveautomation.com/t/error-illegal-type-for-x-value-class-java-lang-string-column-horas/35884/7 "2020-06-22T21:41:10Z")

</div>

I think I already solved, I used DATEPART

```auto
SELECT DATEPART ( hour , Fecha),
SUM(CASE WHEN Linea = 'Linea_Disco' THEN Qty else 0 END) as 'Linea_Disco',
SUM(CASE WHEN Linea = 'Linea_Rim' THEN Qty else 0 END) as 'Linea_Rim',
SUM(CASE WHEN Linea = 'Linea_Assy' THEN Qty else 0 END) as 'Linea_Assy',
SUM(CASE WHEN Linea = 'Linea_ED' THEN Qty else 0 END) as 'Linea_ED',
SUM(CASE WHEN Linea = 'Linea_TC' THEN Qty else 0 END) as 'Linea_TC'
from HistoricoContador
where CONVERT (date,Fecha) = dateadd(day, -0,CAST(GETDATE() as DATE))
GROUP BY DATEPART ( hour , Fecha)
ORDER BY DATEPART ( hour , Fecha) ASC

```