Spring Data Mongodb @Query with pagination

Question

Is there any way to write some query to mongo with @Query annotation and add paginaiton right into it. I have a method in repository

@Query("{'customer._id' : ?0 }")
List<Order> findOrderByCustomerName(String customerName);

and i want it to looks smth like this

@Query("{'customer._id' : ?0 }.skip{(?1 - 1) * ?2}.limit(?2)")
List<Order> findOrderByCustomerName(String customerName, int page, int size);

Is there any way to to it?

Saljack · Accepted Answer · 2022-01-04 12:52:55Z

2

You can add Pageable as a parameter.

@Query("{'customer._id' : ?0 }")
List<Order> findOrderByCustomerName(String customerName, Pageable pageable);

answered Jan 4, 2022 at 12:52

Saljack

2,41525 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Thank you. It's working.