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 (...

Thanks for the response. We already has index for this query, which search only at one path - SELECT p.* FROM [cq:PageContent] AS p WHERE ISDESCENDANTNODE(p,[/content/AA])  AND ( CONTAINS(p.[cq:tags], ‘”testAA”) ) But due to one of the requirement, we have to search at 2 paths now, hence we updated ...

Hello,I want to search the nodes on 2 different paths. For example -> /content/AA and /content/BB. The below query works fine SELECT p.* FROM [cq:PageContent] AS p WHERE ( ISDESCENDANTNODE(p,[/content/AA]) OR ISDESCENDANTNODE(p,[/content/BB]) ) AND ( CONTAINS(p.[cq:tags], ‘”testAA”) ) but throws the...