I'm triing to use a Mulit Select Input Control.
I use a Hibernate connection to the Database.
So i need to use the IN-statement. I found this $X variable, which should do this.
So i tried like this in my EJBQL:
"FROM Taetigkeit t WHERE $X{IN,t.taetigkeitsStufe,klasse}"
t.taetigkeitsStufe can be 1,2,3 or 4. And klasse is a Collection which is filled by the input control.
But now the Problem beginns. If I run this report on the JasperServer I get this error Message:
net.sf.jasperreports.engine.JRRuntimeException: No clause function for id IN found
If I try this in a Report with a JDBC connection and a SQL Query it works fine. But not with Hibernate and EJBQL.
Does anyone had this problem too? Is there a solution or does someone see an error in my way?
Can't $X{IN, ?, ?} be used in a EJBQL?
Thx for answers!
