I have two CMP entity beans AppUser representing user of application and AppRole representing security roles of application. There is bidirectional many-to-many relationship between these two beans. So each user can be assigned to many roles (method appUser.appRoles() returns collection containig user's roles) and each role can be assigned to many users (method appRole.appUsers() returns collection containing role's users). The question is how to create EJB-QL which will return a collection of roles not assigned to given user (user passed as an argument to query)? Or vice versa; how to create EJB-QL which will return a collection of users not assigned to given role (role passed as an argument to query)? I've been trying for few days with many combination (NOT IN, NOT MEMBER OF etc.) but without any success!
View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3866894#3866894 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3866894 ------------------------------------------------------- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click _______________________________________________ JBoss-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jboss-user
