Return-Path: X-Original-To: apmail-jackrabbit-users-archive@minotaur.apache.org Delivered-To: apmail-jackrabbit-users-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 28B381027C for ; Fri, 21 Jun 2013 08:02:47 +0000 (UTC) Received: (qmail 57103 invoked by uid 500); 21 Jun 2013 08:02:46 -0000 Delivered-To: apmail-jackrabbit-users-archive@jackrabbit.apache.org Received: (qmail 56527 invoked by uid 500); 21 Jun 2013 08:02:41 -0000 Mailing-List: contact users-help@jackrabbit.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: users@jackrabbit.apache.org Delivered-To: mailing list users@jackrabbit.apache.org Received: (qmail 56512 invoked by uid 99); 21 Jun 2013 08:02:41 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 21 Jun 2013 08:02:41 +0000 X-ASF-Spam-Status: No, hits=2.2 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_NONE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of ropo@mail.com designates 74.208.4.201 as permitted sender) Received: from [74.208.4.201] (HELO mout.gmx.net) (74.208.4.201) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 21 Jun 2013 08:02:33 +0000 Received: from mailout-us.gmx.com ([172.19.198.46]) by mrigmx.server.lan (mrigmxus002) with ESMTP (Nemesis) id 0MXHDV-1UkqBg1ZGH-00WFoa for ; Fri, 21 Jun 2013 10:02:09 +0200 Received: (qmail 1252 invoked by uid 0); 21 Jun 2013 08:02:09 -0000 Received: from 62.245.147.202 by rms-us020 with HTTP Content-Type: multipart/alternative; boundary="========GMXBoundary246721371801727711566" Date: Fri, 21 Jun 2013 04:02:07 -0400 From: "Rolf Poo" Message-ID: <20130621080207.246720@gmx.com> MIME-Version: 1.0 Subject: Why does this not work? To: users@jackrabbit.apache.org X-Flags: 0001 X-Mailer: GMX.com Web Mailer x-registered: 0 X-GMX-UID: KG22cQQB3zOl2E7v13Ah0nZ+IGRvb0A1 X-Virus-Checked: Checked by ClamAV on apache.org --========GMXBoundary246721371801727711566 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 8bit select * from [mgnl:content] as p1 inner join [mgnl:content] as p2 on ischildnode(p2,p1) where ischildnode(p1,'/') and (name(p1) = 'folder') and (name(p2) = 'file') Hi, Please help me with my query. I am very frustrated. The query above is supposed to find ony the node "/folder/file", but it also matches "/other/somewhere/file" Can you please help me formulating the correct query? I would be grateful forever Thanks, Rolf --========GMXBoundary246721371801727711566--