SQL2 Query

Question

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

- /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 Answer

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 · Answer

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?

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded