Re: searching in double nested list

2008-08-06 Thread Jeremy Bauer
Marc, If I correctly understand the result you seek, you need to do a three way join across the entities. The JPQL below may be what you need (or close to it). The IN() join syntax may also work, but I haven't tried it. "SELECT z FROM Magazine x JOIN x.articles y JOIN y.paragraph z where y.auth

searching in double nested list

2008-08-06 Thread Marc Logemann
HI, i know that i can entities in relations like this: SELECT x FROM Magazine x, IN(x.articles) y WHERE y.authorName = 'John Doe' But what if i have this objectmodel: Magazine->Articles->Paragraphs And now i want to query for paragraph.number = 2 ??? Your example works with a one level n