Return-Path: Delivered-To: apmail-jackrabbit-dev-archive@www.apache.org Received: (qmail 85190 invoked from network); 3 Sep 2007 10:57:48 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 3 Sep 2007 10:57:48 -0000 Received: (qmail 35923 invoked by uid 500); 3 Sep 2007 10:57:42 -0000 Delivered-To: apmail-jackrabbit-dev-archive@jackrabbit.apache.org Received: (qmail 35548 invoked by uid 500); 3 Sep 2007 10:57:42 -0000 Mailing-List: contact dev-help@jackrabbit.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@jackrabbit.apache.org Delivered-To: mailing list dev@jackrabbit.apache.org Received: (qmail 35539 invoked by uid 99); 3 Sep 2007 10:57:42 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 03 Sep 2007 03:57:42 -0700 X-ASF-Spam-Status: No, hits=1.2 required=10.0 tests=SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (nike.apache.org: local policy) Received: from [213.133.33.40] (HELO smtp.is.nl) (213.133.33.40) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 03 Sep 2007 10:58:49 +0000 Received: from [213.133.51.241] (HELO hai01.hippo.local) by smtp.is.nl (CommuniGate Pro SMTP 5.0.10) with ESMTP id 22957221 for dev@jackrabbit.apache.org; Mon, 03 Sep 2007 12:57:16 +0200 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? X-MimeOLE: Produced By Microsoft Exchange V6.0.6619.12 Date: Mon, 3 Sep 2007 12:57:16 +0200 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: How to get the subnodes of a tree using sql? Thread-Index: AcfuE+PPR60LbhAFTbG2rMA7MFuVTwABOVkQ From: "Ard Schrijvers" To: X-Virus-Checked: Checked by ClamAV on apache.org Hello, > 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'"; shouldn't the jcr:path start with /root?=20 Also note that users@apache.org might be a more appropriate list for = your question since it is clearly a user question. Regards Ard