Hi Everyone,
During my learning of Magnolia I've encountered the issue that is my jcr-sql2 query result is not in the same order as I see in the repository browser. Any advice on how to fix this issue is much appreciated.
I am using a separate workspace, and am putting mgnl:skiContent nodes under mgnl:folder. here's the mgnl:skiContent definition:
[code]<nodeTypes
xmlns:rep="internal"
xmlns:nt="
http://www.jcp.org/jcr/nt/1.0"
xmlns:mix="
http://www.jcp.org/jcr/mix/1.0"
xmlns:mgnl="
http://www.magnolia.info/jcr/mgnl"
xmlns:jcr="
http://www.jcp.org/jcr/1.0">
<nodeType name="mgnl:skiContent" isMixin="false" hasOrderableChildNodes="true" primaryItemName="">
<supertypes>
<supertype>mgnl:content</supertype>
</supertypes>
</nodeType>
</nodeTypes>[/code]
I googled around and found some content about this topic, for example this:
https://forums.magnolia-cms.com/forum/thread.html?threadId=9e6cbfa9-453e-478f-a640-b532d130ca35
I have checked the respectDocumentOrder property in repository/workspace.xml and it is set to true. Rebuilding index works temporarily, but if I change the order of the nodes a couple of times it'll start to appear disordered again.