Hi there sure this is really simple for you guys that use this regularly, sorry for such a newbie question.

Im tryin to create a query to return all objectA's based on objectC's Identity

objectA has an instance of objectB assoicated with it
objectC has a collection of objectB's associated with it

objectA objectB objectC

i know you can use a fetch to get all of the objectBs but the rest im lost with!

Thanks

Andy

Something like:

from objectA a left join a.B_Instance b
where :c_instnace in elements(b.C_collection)

thanks, but where does the identity i am searchin on go in that?

you need to pass it in as SetEntity()

if you are talking about the id of C, than it is something like:

from objectA a left join a.B_Instance b left join b.C_Collection c
where c.id = :c_id

sorry if i didnt explain it clearly enough in the origional post but objectB doesnt have the collection

objectC has a collection of objectBs
then objectA has an instance of objectB