[magnolia-user] Re: JCR-SQL2 query result does not respect document order

2016-02-04 Thread Jean Charles (via Magnolia Forums)
Hi, I have the same problem and confirm the Jackrabbit issue with SQL2 I also have the "respectDocumentOrder" value set to true, and after re-indexing my workspace, it worked well, but just once! By moving the nodes again the query still returns another order (seems to be creationDate by defaul

[magnolia-user] Re: JCR-SQL2 query result does not respect document order

2015-11-17 Thread Jim Zhai (via Magnolia Forums)
I assume you meant JQOM? IIRC I saw a line in jackrabbit documents that says SQL2 will be translated into JQOM anyway, there's no benefit whatsoever in using JQOM directly. Although I will give it a try. Thx a lot for the advices. -- Context is everything: http://forum.magnolia-cms.com/forum/t

AW: [magnolia-user] Re: JCR-SQL2 query result does not respect document order

2015-11-17 Thread Unger, Richard
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 shoul

[magnolia-user] Re: JCR-SQL2 query result does not respect document order

2015-11-16 Thread Jim Zhai (via Magnolia Forums)
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 SQ