Order JCR nodes by hierarchy order

Asked Mar 22 '16 at 16:19

Active Mar 31 '16 at 06:05

Viewed 57 times

I have a list of nodes in Magnolia:

But when I put them in a loop, they're coming out in a random order:

SELECT * FROM [mgnl:page] WHERE ISCHILDNODE('/')

What do I need to specify in the ORDER BY clause for the nodes to be ordered the same way as the interface?

edited Mar 31 '16 at 06:05

Wolfgang Fahl

asked Mar 22 '16 at 16:19

bashaus

2

See http://stackoverflow.com/questions/16980029/jcr-sql2-result-query-order-as-in-jcr-browser – Jozef Chocholacek Mar 23 '16 at 07:35
Or you can use old JCR SQL instead of JCR SQL2 - then the nodes come as they are ordered. – Jozef Chocholacek Mar 23 '16 at 07:37

0 Answers0