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
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