🎨 ItemMapperV2: add new offset code (findShared)

Signed-off-by: Marco Nassabain <marco.nassabain@hotmail.com>

1 files changed, 5 insertions, 1 deletions

diff --git a/lib/Db/ItemMapperV2.php b/lib/Db/ItemMapperV2.php
index 5399272ce..c283ca4fd 100644
--- a/lib/Db/ItemMapperV2.php
+++ b/lib/Db/ItemMapperV2.php
@@ -627,7 +627,6 @@ class ItemMapperV2 extends NewsMapperV2
             ->andWhere('items.shared_with = :sharedWith')
             ->setParameter('sharedWith', $userId)
             ->setMaxResults($limit)
-            ->setFirstResult($offset)
             ->orderBy('items.last_modified', ($oldestFirst ? 'ASC' : 'DESC'))
             ->addOrderBy('items.id', ($oldestFirst ? 'ASC' : 'DESC'));
 
@@ -639,6 +638,11 @@ class ItemMapperV2 extends NewsMapperV2
             }
         }
 
+        if ($offset !== 0) {
+            $builder->andWhere($this->offsetWhere($oldestFirst))
+                ->setParameter('offset', $offset);
+        }
+
         if ($hideRead === true) {
             $builder->andWhere('items.unread = 1');
         }