Find an object with a list where an element of the list=valu

strokine · **Joined:** Tue Apr 19, 2005 10:15 am **Posts:** 8

Hibernate version:3.1
How to find an object with a list where an element of the list equal some value?
For example, I have such class:

Code:

class MyClass{
   List<String> myList;
}

I want to do something like this:

Code:

from MyClass o where o.myList='ABC'

Of course it doesn't work.
How can I do this? Is this possible at all?

tenwit · **Joined:** Thu Dec 23, 2004 9:08 pm **Posts:** 2008

Check out the ref docs section 14.9. Here's the pertinent paragraph:

Quote:

HQL functions that take collection-valued path expressions: size(), minelement(), maxelement(), minindex(), maxindex(), along with the special elements() and indices functions which may be quantified using some, all, exists, any, in.

So for the simple case you're asking about, it would be

Code:

from MyClass o where 'ABC' in elements(o.myList)