Hi
For the above query I am not getting response from querybuilder.
I am getting below error
Solved! Go to Solution.
Views
Replies
Total Likes
Hi @mayee_abhishek ,
Run the query with the query builder servlet. It will work in AEM as a cloud service as well. i.e. http://localhost:4502/bin/querybuilder.json?type=cq:Page&path=/content&limits=-1
For original query :
type=cq:Page
path=/content
limits=-1
Please check out the query builder API in AEM as a cloud service - https://experienceleague.adobe.com/docs/experience-manager-cloud-service/content/implementing/develo...
You can also check the query builder search limit from the configuration Apache Jackrabbit Query Engine Settings Service and increase the limit or optimize your query.
Please checkout this reference - https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/what-is-maximum-limit-of-h...
Regards,
Shiv
Try to test this on your local sdk. I'm not sure if the old querybuilderdebugger ist still be supported at the cloud tbh.
Hi @mayee_abhishek ,
Run the query with the query builder servlet. It will work in AEM as a cloud service as well. i.e. http://localhost:4502/bin/querybuilder.json?type=cq:Page&path=/content&limits=-1
For original query :
type=cq:Page
path=/content
limits=-1
Please check out the query builder API in AEM as a cloud service - https://experienceleague.adobe.com/docs/experience-manager-cloud-service/content/implementing/develo...
You can also check the query builder search limit from the configuration Apache Jackrabbit Query Engine Settings Service and increase the limit or optimize your query.
Please checkout this reference - https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/what-is-maximum-limit-of-h...
Regards,
Shiv
The query that you have shared in screenshot would traverse a lot of pages. It might be failing at backend after reaching Max traversal limit.
When in doubt about queries, always check logs for Traversal errors.
https://wttech.blog/blog/2020/jcr-query-performance/ explains about Explain Query tool, which helps you identify if an Index is picked for a query or not.
Please find-tune your query to be more exact. Like a smaller sub-tree.
Hi @mayee_abhishek ,
Try to debug and check if you are getting indexing for your query in the query performance tool:-
http://localhost:4502/libs/granite/operations/content/diagnosistools/queryPerformance.html
In this select the tab explain query and paste your query there.
If there is any indexing issue that is prohibiting your query to execute, you should be able to identify that.
Views
Likes
Replies