Query against @CollectionOfElements

[liudan2005]

I have an entity:

class MyClass{
...
@CollectionOfElements
public Set getNumbers() {
return numbers;
}
}

now I wanna query from this field:
"select m from MyClass as m where m.numbers = '07887234234' "
but it gives me an error. is there any way to query it this way, for example:
"select m from MyClass as m where m.numbers contains '07887234234' "
or
"select m from MyClass as m where m.numbers.itemvalue = '07887234234' "

[liudan2005]

does anyone know?

[chrismalan]

I'm guessing, as nobody else replied.

Try

select m from MyClass m join m.numbers mn where mn=4711

Give it a go and let me know.

Regards,

Chris

[liudan2005]

Great! It works. Thanks Chris.