Hello All,
I have a requirement to remove 'order by' on 'created date' and return the results as added in author dialog.
For Instance - Query is
SELECT p.* FROM [cq:PageContent] AS p WHERE ISDESCENDANTNODE(p, [/content/test/en]) AND p.[cq:template] = '/conf/test/settings/wcm/templates/test1' AND ( p.[jcr:path] in ('/content/test/en/second/jcr:content','/content/test/en/first/jcr:content') )
So, expectation is to get results in the same order (as added in query) -
- /content/test/en/second/jcr:content
- /content/test/en/first/jcr:content
whereas, In actual, getting the results like this
- /content/test/en/first/jcr:content
- /content/test/en/second/jcr:content
Any Suggestions ?
Thanks !!