Pagination for Site and Assets

Hi @chandrika123 , I am assuming that you are trying to add pagination for one of your page, so you should be able to decide it according to the business requirement and UX design.

If you are using querybuilder api, it will return all results with p.limit=-1 (this might be a high number depending on your instance).

If you want to implement pagination then you can use offset and limit like this

path=/content/<project>/us/en/products
type=cq:Page
property=jcr:content/@commerceType
property.value=Product Family
p.guessTotal=true
p.offset=0
p.limit=35

it will give you results 35 at one time. 

Results

Number of hits: 35+

p.guessTotal parameter is to return the appropriate number of results that can be shown by combining the minimum viable p.offset and p.limit values. The advantage of using this parameter is improved performance with large result sets.

p.limit- defines page size. In simple words how many records you want to fetch.

p.offset-defines start of index means from which index you want to fetch records from query result.

Below query will give you all results

path=/content/project/us/en/products
type=cq:Page
property=jcr:content/@commerceType
property.value=Product Family
p.limit=-1

Refer querybuilder cheat sheet- https://github.com/paulrohrbeck/aem-links/blob/master/querybuilder_cheatsheet.md

https://experienceleague.adobe.com/docs/experience-manager-65/developing/platform/query-builder/querybuilder-api.html?lang=en#