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

Ignition
1

Hello I have the next query

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
image1019×506 19.2 KB

2

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

3

yes, this is my query

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
4

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).

1 Like
5

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

6

How about this query ?

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
7

I think I already solved, I used DATEPART

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