Return-Path: Delivered-To: apmail-jackrabbit-users-archive@minotaur.apache.org Received: (qmail 98057 invoked from network); 12 Sep 2009 16:53:59 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 12 Sep 2009 16:53:59 -0000 Received: (qmail 72970 invoked by uid 500); 12 Sep 2009 16:53:58 -0000 Delivered-To: apmail-jackrabbit-users-archive@jackrabbit.apache.org Received: (qmail 72929 invoked by uid 500); 12 Sep 2009 16:53:58 -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 72918 invoked by uid 99); 12 Sep 2009 16:53:58 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 12 Sep 2009 16:53:58 +0000 X-ASF-Spam-Status: No, hits=2.2 required=10.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of savvas.triantafyllou@gmail.com designates 74.125.78.25 as permitted sender) Received: from [74.125.78.25] (HELO ey-out-2122.google.com) (74.125.78.25) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 12 Sep 2009 16:53:48 +0000 Received: by ey-out-2122.google.com with SMTP id 22so394170eye.1 for ; Sat, 12 Sep 2009 09:53:28 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:content-type; bh=EA8/GaNUfKUNPJprslWT9bFhEPk6ANK8PameD3db6cQ=; b=DiJChkBKKZmPxb/eWPwRDVKO9MCYoa0vJrxUPCJPIvew8zTvdLY9wpnMRTPFQUSblU GFUZns3fqeLmMxZbIgdoYAij9Hz2DiMndNZE0n+u4eYourZ/LjlgmIAa5S1xskrCuSpw uwmd0NsxNh0iazkO+821OY0qrrrPx4CUrwmnI= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; b=vOs+aC4NOfgd5+WPUyF+wnnbZMlyLR8vJLDD3/nO3s0z2RW00OyNYWUSamfXPcxrUp XkuY6I5mnDCHAPWdOJvedQgyKCpCWHuXxF1Dtf3LhPzCG+hRfiT0GhNvbxUP2TtHhAm3 C0YU1X0XzCDBqYbGQmy/r5u9panUNmHVLjC4w= MIME-Version: 1.0 Received: by 10.211.154.18 with SMTP id g18mr1095699ebo.65.1252774408353; Sat, 12 Sep 2009 09:53:28 -0700 (PDT) In-Reply-To: <46A30055030F405D95E18F9007047DF5@Dell2> References: <46A30055030F405D95E18F9007047DF5@Dell2> Date: Sat, 12 Sep 2009 19:53:28 +0300 Message-ID: <92121d410909120953o52cfcd76l970d430c4a77c92a@mail.gmail.com> Subject: Re: Query syntax comparing against multiple property values From: Savvas Triantafyllou To: users@jackrabbit.apache.org Content-Type: multipart/alternative; boundary=001636c5975697f83704736445e4 X-Virus-Checked: Checked by ClamAV on apache.org --001636c5975697f83704736445e4 Content-Type: text/plain; charset=ISO-8859-1 Hi, have you tried //element(*, hfs:file)[jcr:contains(., 'testing')]/(@hfs:description | @hfs:formname) BR, Savvas 2009/9/11 Michael Shoener > I am trying to figure out the correct Xpath query for the following SQL > query: > > SELECT hfs:description, hfs:formname FROM hfs:file WHERE CONTAINS(., > 'testing') > > The above query returns all records where either the hfs:description or > hfs:formname contains the value "testing". > > I tried the following in Xpath but it does not work: > > //element(*, hfs:file)/(@hfs:description | > @hfs:formname)[jcr:contains(., 'testing')] > > > What am I missing in my query to make it not return any records? > > > Best Regards, > > Michael Shoener > Support Staff > Software Application Services, Inc. > > > --001636c5975697f83704736445e4--