How to use limit and skip in spring data mongodb repository?

Question

I want query sublist in mongo collections using Spring Data MongoDB. My Code is like

public interface SomeRepo extends MongoRepository<SomeDoc, String> {
    @Query("{'field0': ?0, 'field1': ?1}, {'limit':?2, 'skip':?3}")
    List<SomeDoc> findAllByField0AndFiled1(
        Long field0,
        Long field1,
        Long limit,
        Long skip
    );
}

but limit & skip are not in Query Object

Log is Created query Document{{field0=123, field1=456}} for Document{{}} fields.

how to pass them into query object?

Instead of `@Query` use `@Aggregate`. – prasad_ Feb 28 '22 at 08:14 — prasad_, Feb 28 '22 at 08:14
You can also use Pageable interface – Harshit Mar 01 '22 at 11:43 — Harshit, Mar 01 '22 at 11:43

Yao Yuan · Accepted Answer · 2022-04-17T05:26:28.670

6

Thanks to @prasad_ for the answer. Using @Aggregation can solve my question.

@Aggregation("{'field0': ?0, 'field1': ?1}, {limit': ?2, 'skip': ?3}")
    List<SomeDoc> findAllByField0AndFiled1(
        Long field0,
        Long field1,
        Long limit,
        Long skip
    );

edited Apr 17 '22 at 05:26

answered Feb 28 '22 at 09:01

Yao Yuan

350
3
11

How to use limit and skip in spring data mongodb repository?

1 Answers1

Linked