jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From aimran <aimra...@gmail.com>
Subject How to compare properties of same node?
Date Wed, 08 May 2013 16:10:00 GMT
Say I have nodes as follows:
row1:[name=a, prop1=1, prop2=2]
row2:[name=b, prop1=2, prop2=2]
row3:[name=c, prop1=3, prop2=2]
row4:[name=c, prop1=4, prop2=1]

I want to get rows that have same values in their properties. In the example
above I want to get row2.

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"
returns ALL 4 rows:
[[x.NAME:a][x.prop1:1][x.prop2:2], [x.NAME:b][x.prop1:2][x.prop2:2],
[x.NAME:b][x.prop1:2][x.prop2:2], [x.NAME:b][x.prop1:2][x.prop2:2]].

How can I alter the query to return only row2? Is it possible with SQL2 or

View this message in context: http://jackrabbit.510166.n4.nabble.com/How-to-compare-properties-of-same-node-tp4658631.html
Sent from the Jackrabbit - Users mailing list archive at Nabble.com.

View raw message