Re: [castor-dev] Querying parent depending on child value

[Smith, Kevin]

Title: Message

Do you mean something like this:   select p from com.blah.Parent p where p.child.someValue = $1   If so, that's definitely possible for one-to-one parent/child relationships. I haven't quite figured out how to do one-to-many parent/children using OQL.   --Kevin -----Original Message----- From: Abhay Kulkarni [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 3:34 PM To: [EMAIL PROTECTED] Subject: [castor-dev] Querying parent depending on child value Hi   I need to query for parent depending on value of one of the child table column. I have parent-child relation defined in XML mapping. How do I build the query using OQL ? Is it possible for OQL to select parent using filter for child ?   Thanks Abhay