Sorry, didn't work:
08:26:01,002 INFO [STDOUT] org.jboss.ejb.plugins.cmp.ejbql.ParseException:
Encountered RIGHT at line 1, column 62.
Was expecting one of:
, ...
View the original post :
http://www.jboss.com/index.html?module=bbop=viewtopicp=3966875#3966875
Reply to the post :
I have no idea if this will work, or even if it's legal HQL, but the first
thing I would try is
| SELECT OBJECT(o) FROM ChargingPoint AS o, IN(o.history) AS h RIGHT JOIN
SubNetwork n
| WHERE h.isActive = true
| AND h.beginDate = ?2 AND (h.endDate IS NULL OR h.endDate ?2)
| AND
