Hi, Yes, we have come across this bug also - I assume this is a problem in Jackrabbit, and can't be solved in Magnolia itself. Perhaps someone at Magnolia can confirm?
For us we solved our problem by using XPath instead, but if that isn't an option for you due to missing features in XPath, perhaps JQDOM is option? Does it work as expected there? 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: Montag, 16. November 2015 22:27 > An: Magnolia User List > Betreff: [magnolia-user] Re: JCR-SQL2 query result does not respect > document order > > Hi Richard, > > Thx for your reply. I didn't try it myself. Based what I found on the > internet XPath and SQL1 should be fine. I'm not familiar with XPath > queries so I tried > SQL1 only and it works fine. Problem is, at some point we would want > to utilize the joined query, which is not supported by SQL1 (and I > don't think XPath can do it either) so I can't quite switch away from SQL2. > > -- > 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> ----------------------------------------------------------------
