[SLING-11230] Support Limit and Offset via JcrResourceProvider / findResources

• Type: Improvement
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Component/s: JCR
• Assignee: Dan Klco
• Reporter: Dan Klco
• Created: 28/Mar/22 12:56
• Updated: 27/Oct/22 14:37
• Resolved: 27/Oct/22 14:37

Description

Problem Statement

In addition to not supporting global limits, there are good reasons that a developer may want to return only a sub-set of the query results when executing a query. For example returning the 10 latest uploaded files.

Currently this can be accomplished by executing a query and then only iterating to the 10th item, however a much larger query set may be fetched from the node store than required to service the intended use case.

In addition, to support paging, the current implementation would require retrieving and iterating over the Resources until the desired start point is found then reading the subsequent Resources.

However changing the API contract for the ResourceResolver to either add a new method with the start and limit values would have a non-insignificant ripple effect into the implementations, mocks and providers which would be required to support this new method.

Issue Links

• is fixed by: OAK-9740 Add Support For Limit / Offset Options in Queries
• is related to: SLING-11229 Add Option to Limit JCR Resource Provider Queries
• relates to: OAK-9740 Add Support For Limit / Offset Options in Queries