jackrabbit-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Alexander Klimetschek <aklim...@day.com>
Subject Re: One Question about SQL2
Date Thu, 29 Jul 2010 09:05:04 GMT
I think something like this could work (beware, untested):

SELECT * FROM [my:a] AS p INNER JOIN child AS c ON ISDESCENDANTNODE(p,
c) WHERE c.[jcr:primaryType] = 'my:b' AND c.Prop1 = 'test'

Regards,
Alex

On Wed, Jul 28, 2010 at 21:45, Michael Coldewey <post@coldy.de> wrote:
> Hello,
>
>
>
> sorry, I know, ist the wrong mailinglist, but i am actually not member of
> the users list.
>
>
>
> Perhaps someone would and could answer me.
>
>
>
> Till now I use XPATH for querying the repository, but now I want to change
> to SQL2. The samples in the test case explains the basics, but I didnt
> found, how to make a query to find nodes, which have childs with specific
> properties.
>
>
>
> [my:a]
>
>     [my:b]
>
>        Prop1=‘test‘
>
>
>
>
>
> I want every node [my:a] which have any child with the property ‚Prop1‘ and
> value ‚test‘.
>
>
>
> In xpath, this is really simple to solve, but i dont know to make it in
> SQL2.
>
>
>
> It would be great, if someone give me a hint on this.
>
>
>
> Thanks a lot
>
> BR,
>
> Michael Coldewey
>
>
>
>



-- 
Alexander Klimetschek
alexander.klimetschek@day.com

Mime
View raw message