Yes here are what i have tried:I did set reindex to true and the value did increase.I also did check the complete path and the page exists.I have also tried some different pages as well but its not working either.I have checked the sling logs to make sure the reindexing has completed.They have the s...

thanks for your help but unfortunately it is still not working It is still showing index without query. Is it working on your end? 

For some context, I need to access component nodes in all pages. So that's why there's a regex in the includedPath so it only contains regex of the root folder. I have asked a similar question a few days ago and it worked for the first time in my local: https://experienceleaguecommunities.adobe.com/...

I have added the index definition in the oak-index folder. I made sure it was indexed correctly. However, when I ran the query explain of the below query, the index was not being used. The index definition is supposed to improve the query below because it is trying to access the descendent nodes ins...

I have added a custom index for cqPageLucene but its not showing up on CRXDE after deploying on local. cqPageLucene already has a few indexes. So in content.xml is only adding the custom index.  <?xml version="1.0" encoding="UTF-8" ?><root xmlns:jcr="http://www.jcp.org/jcr/1.0" xmlns:cq="http://www....

Thanks. After I add the xml file to the oak-index, it should be reflected on CRXDE right? For some reason, it is not showing up

I know some of the indexes are OOTB from Adobe in cqPageLucene. I need to add additional index such as pageReplicationAction in cqPageLucene so I would like to see if the .content.xml would be correct like below: <?xml version="1.0" encoding="UTF-8"?><jcr:root xmlns:oak="http://jackrabbit.apache.org...

I have more than 1000 pages to query and the query will traverse nodes inside each page node to get component nodes. Let's assume all these pages are under the same parent node: /content/costco/, and this is what queries look like: SELECT page.[jcr:path] FROM [nt:base] AS s WHERE ISDESCENDANTNODE([/...

Thanks for your reply! This is super thorough. I was wondering if I have thousands of pages, do I need to add these paths one by one like below?  <includedPaths jcr:primaryType="nt:unstructured"> <content jcr:primaryType="nt:unstructured" name="/content/homepage0/jcr:content"/> <conte...

I have a SQL2 query that needs indexing: SELECT * FROM [nt:base] AS s WHERE ISDESCENDANTNODE([/content/homepage/jcr:content]) But I got this error:no proper index was found for filter Filter(query=explain SELECT * FROM [nt:base] AS s WHERE ISDESCENDANTNODE([/content/homepage/jcr:content]) , path=/co...