jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Alexander Klimetschek <aklim...@adobe.com>
Subject Re: How to compare properties of same node?
Date Thu, 09 May 2013 19:04:26 GMT
On 08.05.2013, at 18:10, aimran <aimran50@gmail.com> wrote:

> However, using inner join SQL2 query: "select x.NAME,x.prop1,x.prop2 from
> [nt:unstructured] as x inner join [nt:unstructured] as y on x.prop1=y.prop2"
> 
> How can I alter the query to return only row2? Is it possible with SQL2 or
> XPATH?

No, for sure not with XPATH [0], but SQL2 also can only join on the node level, but not based
on property equality either [1].

[0] http://www.day.com/specs/jcr/1.0/6.6.3.3_Property_Constraint.html
[1] http://www.day.com/specs/jcr/2.0/6_Query.html#6.7%20Abstract%20Query%20Model%20and%20Language%20Bindings

Cheers,
Alex
Mime
View raw message