You are viewing a plain text version of this content. The canonical link for it is here.

Posted to oak-issues@jackrabbit.apache.org by "Dan Klco (Jira)" <ji...@apache.org> on 2022/03/29 14:11:00 UTC

[jira] [Created] (OAK-9740) Add Support For Limit / Offset Options in Queries

Dan Klco created OAK-9740:
-----------------------------

             Summary: Add Support For Limit / Offset Options in Queries
                 Key: OAK-9740
                 URL: https://issues.apache.org/jira/browse/OAK-9740
             Project: Jackrabbit Oak
          Issue Type: Improvement
          Components: query, search
    Affects Versions: 1.42.0
            Reporter: Dan Klco
             Fix For: 1.44.0


*Problem Statement*

When creating queries, developers can specify the limit / offset by calling the appropriate method on the javax.jcr.Query object. However there is not an option to do so in the body of the query statement itself. 

Therefore, when either using an [existing UI|https://www.composum.com/home/nodes/browser/queries.html] or [existing API|https://sling.apache.org/apidocs/sling12/org/apache/sling/api/resource/ResourceResolver.html#findResources-java.lang.String-java.lang.String-] that does not support setting these values, it's possible to construct a query that runs against indexed data but still fails due to reading too many nodes.

*Solution*

Add support for setting the offset / limit via [options|https://jackrabbit.apache.org/oak/docs/query/query-engine.html#Query_Options] 



--
This message was sent by Atlassian Jira
(v8.20.1#820001)