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

["Dan Klco (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/OAK-9740?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17515530#comment-17515530 ] 

Dan Klco commented on OAK-9740:
-------------------------------

PR created: https://github.com/apache/jackrabbit-oak/pull/535

> 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
>            Priority: Major
>             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)