How to query for coll owner based on contained element prop?

bonnyr · **Posted:** Thu May 05, 2005 3:29 am

If I have the following setup:

Code:

class A { Set<B> bs; }
class B { C ref; }
class C { int id; }

How do I form a query that returns instances of A that have members
of their B collection point to a certain instance of C based on the
property value of prop

in JDO I've seen the contains method which seems to do what is
needed something like (a.contains(b) && b.c.id = :id). Can it be done in H3?

steve · **Posted:** Thu May 05, 2005 10:56 am

Code:

select a from A as a inner join a.bs as b where b.c.id = :id

bonnyr · **Posted:** Thu May 05, 2005 6:16 pm

steve wrote:

Code:

select a from A as a inner join a.bs as b where b.c.id = :id

Thanks!