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

I am trying to create custom index on jcr:content/cq:lastReplicationAction on AEM but for some reason it complained about "Not A Valid JCR Name"   Am I missing something here?

If I uninstall the current ui.content package on CRXDE, would AEM automatically install the previous version of ui.content package? Or would I have empty content completely?

Thanks for your reply. I am referring to log in user, not service user. It is similar to how user login when in home page: http://localhost:4503/aem/start.html except I am looking to create one in higher environment. Is it possible to do so?