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