In Query Builder JSON Response Results and Total are coming as different Values | Community
Skip to main content
P
PoovithaSelvaraj
Level 3
February 10, 2023
Solved

In Query Builder JSON Response Results and Total are coming as different Values

  • February 10, 2023
  • 2 replies
  • 2938 views

I am using Query Builder API to query through the documents matching certain criteria, Here is the sample query from query debug tool,

path=/content/dam/mchp/documents
type=dam:Asset
property.and=true
1_property=jcr:content/metadata/mchp:document-category
1_property.value=documents:product-documents/code-examples
2_property=jcr:content/metadata/mchp:document-application
2_property.operation=exists
p.hits=selective
p.properties=jcr:title
p.nodedepth=5
p.limit=-1

 

When I see the result as JSON response , 

 

Both Results and Total are different values. In API also results are coming as 283 only. 
Wanted to know what is the difference between total and result ? and Y it is coming as different values?

 

Thanks in Advance.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Chandra_Hire

Hi @chandra_hire , 

p.limit i am setting as -1. 

"success": true,

"results": 262,

"total": 970,

"more": false,

"offset": 0,


Hi @poovithaselvaraj 

Can you try adding p.guessTotal=1000 and remove p.limit ? so it will read up to 1000, to get exact total. But if total is more than 1000, then 'more' will be true and you need to extract the result using offset until 'more' gets false.

2 replies

Kiran_Vedantam
Community Advisor
Kiran_VedantamCommunity Advisor
Community Advisor
February 10, 2023

Hi @poovithaselvaraj 

 

Ideally the query run in the query builder and Query builder API should return the same hits. Can you check if you are missing any properties like p.limit etc which is making the results come low?

 

Thanks,
Kiran Vedantam

    P
    PoovithaSelvarajAuthor
    Level 3
    February 14, 2023

    I have added p.limit to the query still it is not matching.

     

    Thanks,

    Poovitha S

      Chandra_Hire
      Chandra_Hire
      Level 4
      February 14, 2023

      what value added as p.limit and what's the value of more field? Please share the query output.

        Chandra_Hire
        Chandra_Hire
        Level 4
        February 11, 2023

        Hi @poovithaselvaraj 

        'total' in JSON result is an outcome of SearchResult.getTotalMatches() method call and Returns the total number of matches or the total as far as it is known. This depends on the query, i.e. it might just retrieve the minimum necessary up to getStartIndex() + getHitsPerPage(). In your case 'more' is false it means getTotalMatches() returned the exact number of Hits.
        Also, 'result' in JSON is an outcome of SearchResult.getHits() and which is a List of Hits to display on the result page. though p.limit is set to -1 to display all the results (total filed in json), Querybuilder by default sets the number of hits to be returned as 'result' (getHits()) based on the query. This can be verified with JCR API SearchResult.getHitsPerPage() and should return the number equal to the number displayed in 'result' field of JSON. In your case it should be 283. 

        You can add pagination (offset/limit/guessTotal) to traverse all Hits (results). Hope this helps.

         

        Have a look for reference

        SearchResult (The Adobe AEM Quickstart and Web Application.)

        Query Builder API | Adobe Experience Manager

          Terms & ConditionsAccessibility statement

          Loading footer...