Mailing-List: contact dev-help@jackrabbit.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@jackrabbit.apache.org
Received-SPF: pass (herse.apache.org: domain of marcel.reutegger@gmx.net
 designates 213.165.64.20 as permitted sender)
Message-ID: <467BA418.2030402@gmx.net>
Date: Fri, 22 Jun 2007 12:27:36 +0200
From: Marcel Reutegger <marcel.reutegger@gmx.net>
User-Agent: Thunderbird 1.5.0.12 (Windows/20070509)
MIME-Version: 1.0
To: dev@jackrabbit.apache.org
Subject: Re: jcr:deref() in predicate
References: <EC213738EDD1C348BBE6012077FB746B0778D6@asterion.legisway.com>
In-Reply-To: <EC213738EDD1C348BBE6012077FB746B0778D6@asterion.legisway.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit

Fr�d�ric Esnault wrote:
> Thansk I will because if we don't have, how can we do this query.
> 
> I want all contracts having as an internal contractor the company Lycos.
> Knowing that contractors are references in the contract type.
> 
> I did /jcr:root/lgw:root/lgw:contracts/element(*, lgw:contractType)[jcr:deref(@lgw:internalContractor, 'lgw:contractorType')/@lgw:companyName = 'Lycos']
> 
> Is there antoher way to make this query?

yes, there is. only search for the company node:

lgw:root//element(*, lgw:company)[@lgw:companyName = 'Lycos']

then use the API to get the references to the lycos company node:

Node lycosCompany = ...;
for (PropertyIterator it = lycosCompany.getReferences(); it.hasNext(); ) {
     Property p = it.nextProperty();
     if (p.getName().equals("lgw:internalContractor")) {
         Node contractType = p.getParent();
         // do something with this node
     }
}

or even better, if there were no same name siblings you could directly address 
the lycos company by path:

Node rootNode = ...;
rootNode.getNode("lgw:root/companies/Lycos");

that way you don't even have to execute a query.

in contrast to databases you don't necessarily have to use joins to get to your 
content along references. the JCR API provides methods to do that much quicker 
than a query.

regards
  marcel