Hi,

I'm trying to verify if some list element is equals to some element of another list. E.g.:

User has a list/collection of AccessPermition;
Place has a list/collection of AccessPermition;

To access a Place, a User must be any AccessPermition contained in Place list of AccessPermition.

i'ld like to implement it using Criteria, but, either solution is welcome ;)

thz...

Umm, you could do something like this:



where user_id is the user in question and place_id is a place. If you remove the u.id = :user_id part you get the id of all the users that have access to the given place. There might be some small problems in the HQL since I didn't run it myself.


Farzad-

Hi farzad.

I don't knew members of "operator". It's a Hibernate function or of some specific DBMS?
Do you think it's possible using Criteria API? Some like contains method of Collections (myCollection.contains(eitherElementOfOtherList)) ...

So, thanks for explain

It's a HQL expression, look at hibernate document section "14.10. Expressions". I will look if this translates into the Criteria API; however, why do you only want to use Criteria?


Farzad-