AEM Querybuilder API giving different result compare to Query debugger/query performance tool | Community
Skip to main content
gurup34365977
gurup34365977
Level 2
Jun 2, 2020 11:57 AM UTC
Solved

AEM Querybuilder API giving different result compare to Query debugger/query performance tool

Hi All,

 

Recently we have upgraded our system to 6.3 to 6.5. When we execute query using Querybuilder API it is giving double when compare with query execution with Query debugger/query performance tool. It is giving blank values when we use Querybuilder API.It is picking proper custom index also ,in our 6.3 instance it is giving proper result. 

 

For instance, when i execute query 

Query debugger/query performance tool(/libs/granite/operations/content/diagnosistools/queryPerformance.html) - the result is 145 in total

Querybuilder API giving result - 290 in total result for same query. out of which 145 it is giving proper result 145 with blank records.

 

Please help me what might be causing the issue.

 

Regards,

Guru Pavan

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
leoberliantAccepted solution
Employee
Jun 2, 2020 12:57 PM UTC

Do you use the exact same syntax in the queryPerformance and in query builder? Does it employ the same index in both cases?

View reply

13 replies

arunpatidar
arunpatidar
New Participant
Jun 3, 2020 7:14 PM UTC

If it doesn't help, could you please share your Query from we-retail section?

Try same in AEM vanilla instance as well. It seems issue could be with instance.

Translate
Arun Patidar
    gurup34365977
    gurup34365977Author
    Level 2
    Jun 4, 2020 1:19 PM UTC
    Hi Arun,
    Translate
    sunjot16
    sunjot16
    Employee
    Jun 2, 2020 2:34 PM UTC

    I also remember something. They had to make some changes according to QueryBuilder API for 6.5 to get the desired results.

    Translate
    gurup34365977
    gurup34365977Author
    Level 2
    Jun 2, 2020 5:23 PM UTC
    Can you please provide exact details QueryBuilder API for 6.5
    Translate
    sunjot16
    sunjot16
    Employee
    Jun 2, 2020 1:59 PM UTC

    Try reindexing that index. It helped resolve the case for one of my customers. They had somewhat similar scenario of migration from 6.3 to 6.5 and issues in retrieving the correct number of records using the QueryBuilder API with their custom index.

    Translate
    gurup34365977
    gurup34365977Author
    Level 2
    Jun 2, 2020 5:26 PM UTC
    Actually when 6.3 to 6.5 upgrade done, same time reindex triggered and succeeded. I will do once again reindexing?
    Translate
    leoberliantAccepted solution
    Employee
    Jun 2, 2020 12:57 PM UTC

    Do you use the exact same syntax in the queryPerformance and in query builder? Does it employ the same index in both cases?

    Translate
    gurup34365977
    gurup34365977Author
    Level 2
    Jun 2, 2020 5:29 PM UTC
    Yes I have used same syntax and same properties ,values,groups. Both the cases it is picked same index . As mentioned earlier only difference is with Query builder API I am getting double result, out of that half of the result is empty records.
    Translate
    Terms & ConditionsAccessibility statement

    Loading footer...