jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Alexander Klimetschek <aklim...@adobe.com>
Subject Re: Keep nodes order with JCR-SQL2 queries
Date Mon, 02 May 2011 13:57:51 GMT
On 02.05.11 15:44, "Charles Flond" <cflond@jahia.com> wrote:
>Now, I perform a JCR-SQL2 query like that : select * from [jnt:content] as
>content where ISDESCENDANTNODE(content,'/sites/demo/home/maincontent/')

Don't use a query for this, but the navigational access:

session.getNode("/sites/demo/home/maincontent/").getNodes()

This gives you the order, will be faster & more efficient than a query.

Regards,
Alex

-- 
Alexander Klimetschek
Developer // Adobe (Day) // Berlin - Basel





Mime
View raw message