Mailing-List: contact users-help@jackrabbit.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@jackrabbit.apache.org
Received-SPF: neutral (athena.apache.org: local policy)
content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Subject: RE: How to get the  subnodes of a tree using sql?
Date: Tue, 4 Sep 2007 08:58:37 +0200
Message-ID: <A955EA1F8FE31749AEC8C998082F6C7C01AC1442@hai01.hippo.local>
Thread-Topic: How to get the  subnodes of a tree using sql?
Thread-Index: AcfumJ1LTDTf1+gSSK6q7BU176INCQAJrNrwAABV3lA=
From: "Ard Schrijvers" <a.schrijvers@hippo.nl>
To: <users@jackrabbit.apache.org>

And now with the correct user list :-)=20

> Hello,
>=20
> when adding the nodes, print out the getPath() to see their=20
> absolute paths. Use this path in the jcr:path. I just tested=20
> it for the trunk and it works without any problems
>=20
> Regards Ard
>=20
> ps I am crossposting to the user list. Continue the thread=20
> over there pls since that is the correct list
>=20
> >=20
> > sorry for not specify clearly and thanks for you reply.
> > the root node is the default "root" node=20
> > i use session.getRootNode() to get the default root node.
> > then i add "domain" nodes as children of "root" node,then=20
> > "information"
> > nodes as children of "domain" node,and "news"  nodes children of
> > "information" node. then save.
> > but now i want to select some "news" nodes from this tree, i=20
> > use sql query
> > but get nothing.
> > i follow your sugguestion to modify the jcr:path,but still=20
> get nothing
> >  jcr:path=3D'/jcr:root/domain/information/news'";
> > other paths:'/domain/information/news'
> > /root/domain/information/news
> > also used,still get nothing.
> >=20
> >=20
> > =20
> >=20
> > Ard Schrijvers wrote:
> > >=20
> > > Hello,
> > >=20
> > >> Andvar wrote:
> > >> the structure of the nodes is as follows:
> > >>                   root
> > >>                     |
> > >>                   domain
> > >>                     |
> > >>                   information
> > >>                     |
> > >>                   news
> > >> I use sql to search the news nodes like this:"select * from=20
> > >> nt:unstructured
> > >> where jcr:path=3D'domain/information/news'";
> > >=20
> > > shouldn't the jcr:path start with /root?=20
> > >=20
> > > Also note that users@apache.org might be a more appropriate=20
> > list for your
> > > question since it is clearly a user question.
> > >=20
> > > Regards Ard
> > >=20
> > >=20
> > >=20
> >=20
> > --=20
> > View this message in context:=20
> http://www.nabble.com/How-to-get-the--subnodes-of-a-tree-using
-sql--tf4371364.html#a12470569
Sent from the Jackrabbit - Dev mailing list archive at Nabble.com.