mardi 19 mai 2015

NamedQueries openjpa JAVA EE

I Explain the situation :) So I have to classes Users and Projects which are related with Many-to-many. Users are affected to project . SO I need to get the list of users which are not affected to the project. I Have tested this one but not work : @NamedQuery(name = "getQuery" , query="SELECT u FROM User u LEFT JOIN u.projects p WHERE p.id=:projectId AND u.id NOT IN (:listUser)"),

Thank You :)

Aucun commentaire:

Enregistrer un commentaire