[ https://issues.apache.org/jira/browse/JCR-2302?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Marcel Reutegger resolved JCR-2302. ----------------------------------- Resolution: Invalid Resolving as invalid. > Child axis support in order by clause does not work > --------------------------------------------------- > > Key: JCR-2302 > URL: https://issues.apache.org/jira/browse/JCR-2302 > Project: Jackrabbit Content Repository > Issue Type: Bug > Components: jackrabbit-core, jackrabbit-spi-commons, xpath > Affects Versions: 2.0-alpha9 > Reporter: Alexander Klimetschek > Priority: Minor > > Child axis support for order by in xpath queries was introduced with JCR-800. > In my use case I have a cq:Page nodetype which has a jcr:content child of > type cq:PageContent (like nt:file and nt:resource). The jcr:content child has > a cq:lastModified time stamp that I want to search on. I use descending to > see the most recently modified nodes at the top. > The problem is that it does not work when using a child axis in the order by: > (1) //element(*, cq:Page) order by @jcr:content/cq:lastModified descending > This gives a different (and wrong) result compared to the simpler query on > level deeper, which returns the correct results: > (2) //element(*, cq:PageContent) order by @cq:lastModified descending > Switching between ascending and descending in (1) does not change the result > set at all, ie. the order stays the same. > A reason could be non-existing properties (of which there are some in my > data), so to only look at existing properties, I run this query, which still > gives incorrect results: > (3) //element(*, cq:Page)[jcr:content/@cq:lastModified] order by > @jcr:content/cq:lastModified descending -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.