hibernate - Ejbql query with in in where clause -


i try query :

select x compteutilisateur x, mail m m.adresse = :param_mail , m in (x.listemail) 

i fails, query generated clause :

where compteutil0_.id=listemail2_.fk__compte__id  , listemail2_.fk__mail__id=mailimpl3_.id  , mailimpl1_.adresse=?  , (     mailimpl1_.id in (         .     ) ) 

what missing ? possible whant ? :)

in using sub query, try member of.

select x compteutilisateur x, mail m m.adresse = :param_mail , m member of x.listemail 

Comments

Popular posts from this blog

php - Magento - Deleted Base url key -

javascript - Tooltipster plugin not firing jquery function when button or any click even occur -

java - WrongTypeOfReturnValue exception thrown when unit testing using mockito -