Mailing-List: contact dev-help@jackrabbit.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@jackrabbit.apache.org
Received-SPF: pass (nike.apache.org: domain of aklimets@day.com designates
 207.126.148.96 as permitted sender)
MIME-Version: 1.0
In-Reply-To: <005c01cb2e8d$7ec5a6a0$7c50f3e0$@de>
References: <005c01cb2e8d$7ec5a6a0$7c50f3e0$@de>
Date: Thu, 29 Jul 2010 11:05:04 +0200
Message-ID: <AANLkTimehpJpx03PmHKBXx0Qs5xmGMDSLzoL3kR+Jf9W@mail.gmail.com>
Subject: Re: One Question about SQL2
From: Alexander Klimetschek <aklimets@day.com>
To: dev@jackrabbit.apache.org
Content-Type: text/plain; charset=windows-1252
Content-Transfer-Encoding: quoted-printable

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] =3D 'my:b' AND c.Prop1 =3D '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 chang=
e
> 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]
>
> =A0=A0=A0 [my:b]
>
> =A0=A0=A0=A0=A0=A0 Prop1=3D=91test=91
>
>
>
>
>
> I want every node [my:a] which have any child with the property =82Prop1=
=91 and
> value =82test=91.
>
>
>
> 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
>
>
>
>


--=20
Alexander Klimetschek
alexander.klimetschek@day.com