$X in EBJQL Query

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!

cyrill.baumann's picture
Joined: Sep 21 2012 - 12:57am
Last seen: 10 years 6 months ago

0 Answers:

No answers yet