SQL2 Query

[srajput-woolies]

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 !!

[Ritesh_Mittal · Accepted solution]

Hi @srajput-woolies ,

It seems the natural ordering is being applied by default. Is it possible you can apply sorting based on some attribute you are going to fetch from theses nodes as per business requirement?

Another solution is to run the query on each node and then add the result.

Thanks,

Ritesh Mittal

[BrianKasingli]

What's the exact usecase? Maybe instead of using the JCR_SQL2, you can get the resource of that particular path, and then get childrens of that resource?