You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@jackrabbit.apache.org by th...@apache.org on 2021/10/22 13:29:13 UTC
svn commit: r1894477 - /jackrabbit/site/live/oak/docs/query/query-engine.html

Author: thomasm
Date: Fri Oct 22 13:29:13 2021
New Revision: 1894477

URL: http://svn.apache.org/viewvc?rev=1894477&view=rev
Log:
OAK-936: Site checkin for project Oak Documentation-1.41-SNAPSHOT

Modified:
    jackrabbit/site/live/oak/docs/query/query-engine.html

Modified: jackrabbit/site/live/oak/docs/query/query-engine.html
URL: http://svn.apache.org/viewvc/jackrabbit/site/live/oak/docs/query/query-engine.html?rev=1894477&r1=1894476&r2=1894477&view=diff
==============================================================================
--- jackrabbit/site/live/oak/docs/query/query-engine.html (original)
+++ jackrabbit/site/live/oak/docs/query/query-engine.html Fri Oct 22 13:29:13 2021
@@ -1,13 +1,13 @@
 <!DOCTYPE html>
 <!--
- | Generated by Apache Maven Doxia Site Renderer 1.8.1 at 2021-10-14 
+ | Generated by Apache Maven Doxia Site Renderer 1.8.1 at 2021-10-22 
  | Rendered using Apache Maven Fluido Skin 1.6
 -->
 <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
   <head>
     <meta charset="UTF-8" />
     <meta name="viewport" content="width=device-width, initial-scale=1.0" />
-    <meta name="Date-Revision-yyyymmdd" content="20211014" />
+    <meta name="Date-Revision-yyyymmdd" content="20211022" />
     <meta http-equiv="Content-Language" content="en" />
     <title>Jackrabbit Oak &#x2013; The Query Engine</title>
     <link rel="stylesheet" href="../css/apache-maven-fluido-1.6.min.css" />
@@ -156,7 +156,7 @@
 
       <div id="breadcrumbs">
         <ul class="breadcrumb">
-        <li id="publishDate">Last Published: 2021-10-14<span class="divider">|</span>
+        <li id="publishDate">Last Published: 2021-10-22<span class="divider">|</span>
 </li>
           <li id="projectVersion">Version: 1.41-SNAPSHOT</li>
         </ul>
@@ -524,12 +524,35 @@ order by @jcr:lastModified, @jcr:path
     + nt:file
       + properties
         + jcrLastModified
-          - name = jcr:lastModified
+          - name = &quot;jcr:lastModified&quot;
           - propertyIndex = true
           - ordered = true
 </pre></div></div>
 
-<p>Notice that multiple entries with the same modified date might exist. If your application requires that the same node is only processed once, then additional logic is required to skip over the entries already seen (for the same modified date).</p></div>
+<p>Notice that multiple entries with the same modified date might exist. If your application requires that the same node is only processed once, then additional logic is required to skip over the entries already seen (for the same modified date).</p>
+<p>If there is no good property to use keyset pagination on, then the lowercase of the node name can be used. It is best to start with <tt>$lastEntry</tt> as an empty string, and then in each subsequent run use the lowercase version of the node name of the last entry. Notice that some nodes may appear in two query results, if there are multiple nodes with the same name.</p>
+
+<div>
+<div>
+<pre class="source">/jcr:root/content//element(*, nt:file)
+[fn:lower-case(fn:name()) &gt;= $lastEntry] 
+order by fn:lower-case(fn:name()), @jcr:path
+
+/oak:index/fileIndex
+  - type = lucene
+  - compatVersion = 2
+  - async = async
+  - includedPaths = [ &quot;/content&quot; ]
+  - queryPaths = [ &quot;/content&quot; ]
+  + indexRules
+    + nt:file
+      + properties
+        + lowercaseName
+          - function = &quot;lower(name())&quot;
+          - propertyIndex = true
+          - ordered = true
+</pre></div></div>
+</div>
 <div class="section">
 <h3><a name="Full-Text_Queries"></a>Full-Text Queries</h3>
 <p>The full-text syntax supported by Jackrabbit Oak is a superset of the JCR specification.</p>