SOLVED
Not getting response from Querybuilder api
Hi
For the above query I am not getting response from querybuilder.
I am getting below error
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
</head>
<body>
<noscript>AEM Cloud Service.</noscript>
<div id="root" status="503" backend="91530c0b88d94723658fbdea70611f93--F_Skyline_Origin_Ingress_Author" healthy="1"
gen="0" rid="c353be71-c5cf-45a9-9840-6819d71ee958" xid="1768318060" age="0.000" ttl="0.000" restarts="0"
nobranding="true"
statusApi="https://dev-console-ns-team-aem-cm-prd-n83310.ethos18-prod-va7.dev.adobeaemcloud.com/api/releases/ns...">
</div>
</body>
</html>
1 Accepted Solution
Correct answer by
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
Shiv Prakash
Correct answer by
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
Shiv Prakash
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.
Aanchal Sikka
