If I enable multi-select in a table, I disable cache than I select one or more values, the database returns this error:
jdbc.SQLServerException: An expression of non-boolean type specified in a context where a condition is expected, near ','.
The error is due to MSSQL not accepting IN statements over list of sets. this is the query I got from the losgs:
select "ATC_1" AS "ATC_1", SUM("Importo_Scarto") AS "Importo_Scarto", SUM("Q_Scarto") AS "Q_Scarto"
from (SELECT [ATC_1] ,[MESE] ,[ANNO] ,[Q_Scarto] ,[Importo_Scarto] FROM [dbo].[MyTable]) T
where (("ANNO","MESE") IN ('2017','10'),('2017','11'),('2018','01'),('2018','02'),('2018','03')
and ("Invio") IN ('3'),('1'),('2') )
group by "ATC_1"
Is there a way I can fix this?
