Hi, Does the problem also exist with an XPath query?
Regards from Vienna, Richard > -----Ursprüngliche Nachricht----- > Von: user-list-ow...@magnolia-cms.com > [mailto:user-list-owner@magnolia- cms.com] Im Auftrag von Jim Zhai > (via Magnolia Forums) > Gesendet: Donnerstag, 12. November 2015 23:24 > An: Magnolia User List > Betreff: [magnolia-user] JCR-SQL2 query result does not respect > document order > > 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. > > -- > Context is everything: http://forum.magnolia- > cms.com/forum/thread.html?threadId=11dc162e-fab4-47a4-aecc- > 61602b4aa711 > > > ---------------------------------------------------------------- > For list details, see http://www.magnolia-cms.com/community/mailing- > lists.html > Alternatively, use our forums: http://forum.magnolia-cms.com/ To > unsubscribe, E-mail to: <user-list-unsubscr...@magnolia-cms.com> > ---------------------------------------------------------------- ---------------------------------------------------------------- For list details, see http://www.magnolia-cms.com/community/mailing-lists.html Alternatively, use our forums: http://forum.magnolia-cms.com/ To unsubscribe, E-mail to: <user-list-unsubscr...@magnolia-cms.com> ----------------------------------------------------------------