jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Davide Giannella <dav...@apache.org>
Subject Re: 'order by' descendant property with multiple descendant
Date Tue, 13 Jan 2015 07:53:10 GMT
On 13/01/2015 05:21, Torgeir Veimo wrote:
> I'm in need of ordering some node in a query based on the latest
> timestamp on one or more child nodes.
>
> This is similar to an article with comments as child nodes, where one
> would like to order the articles in a query sorted by the last
> timestamp on the comments to each article.
>
> This doesn't seem to be work using an XPATH query, with a child node
> designator as eg */@createdProperty. IS this possible to do using
> either SQL2 or by using the QOM?
>
Don't know off the top of my head the actual details but probably you
can achieve it with inner joins.

http://www.day.com/maven/jcr/2.0/6_Query.html#6.7.5%20Join

HTH
Davide



Mime
View raw message