Mailing-List: contact users-help@jackrabbit.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@jackrabbit.apache.org
Received-SPF: pass (athena.apache.org: domain of rodrigo.meza.forms@gmail.com
 designates 74.125.92.27 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:date:message-id:subject:from:to:content-type;
        b=BKHa4i165CinVSQ/QDIwlAuM5bSaV2oLOMBjcfLi7UHOwNVQtkrA3q/vxChUO0+WBU
         T8xsgabcxYvQJ4BwCWlujWiY+TQvbO6Ig0VWBOG28oJd10IbqADqkVqRCTKN8PzcZdu6
         9RAqoXOVqFYE/1PjeMHidMjPqIqRJZiIEhg/E=
MIME-Version: 1.0
Date: Fri, 19 Mar 2010 18:21:27 -0300
Message-ID: <db723b791003191421u42255381seb523cdb8dc68527@mail.gmail.com>
Subject: searching in all the properties of a node
From: Rodrigo Meza <rodrigo.meza.forms@gmail.com>
To: users@jackrabbit.apache.org
Content-Type: text/plain; charset=ISO-8859-1

Hello,
   Using the Xpath querying syntax, I used to search in all of the
properties of node of type my:nodetype the text 'a search string' in
this way:

queryManager.createQuery("//element(*,my:nodetype")[jcr:contains(., 'a
search string')]", Query.XPATH);

   Is there an equivalent way to search in all the properties of a set
of nodes with a common nodetype using JCR-SQL2? I've tried replacing
the column name with a dot (as in the XPATH syntax) or with a * (as is
suggested by looking at  the examples from Jackrabbit's test cases),
but none of them work well (I get a
javax.jcr.query.InvalidQueryException).

thanks,
  Rodrigo.