Hi!

How can I query collection elements? What I mean by that is that persistent object has a property (collections) which holds other (same type) objects. I want to query those objects. I've written the query

select elements(p.Friends) as friends from Person p where p.ID = " + p.ID + "friends.Name like '" + searchPattern + "'"

and this produces an error " , expected in SELECT".

What I want from this query (if it is not obvious) is to filter friends collection based on the Name property of the object. The Friends collection holds Person objects -- the same type as the "parent" object.


Thanks,
Miha

you are missing an AND operator?

you are missing an AND operator?

Actually, the query I wrote was wrong. Hibernate had problems with friends.Name;

Thanks to gavin@hibernate I found out that I can use p.Friends as a table.

So, what I really needed is


Thanks for posting,
Miha.