How to select between dates Spring data MongoDB using @Query

Question

I'm using Spring data with MongoDB and i need to find between actual day and 7 days ahead.

I have create repsoitories with @Query annotation and don't like to user Criteria class.

Do you have some idea how to user between with @Query?

thanks in advance.

s7vr · Answer 1 · 2017-04-29T18:44:58.673

5

You can try below query.

Using @Query annotation

@Query(value = "{'date':{ $lt: ?0, $gt: ?1}}")
List<SomeClass> findByDateBetween(Instant from, Instant to);

Or

Using repository supported keywords

List<SomeClass> findByDateBetween(Instant from, Instant to);

edited Apr 29 '17 at 18:44

answered Apr 29 '17 at 18:39

s7vr

the @Query solution solves my problem, thanks a lot!! – Apr 30 '17 at 20:03
Is there a way to have this work while also including additional criteria to filter on? – Igneous01 Sep 15 '20 at 13:07

score 0 · Answer 2 · answered Sep 17 '18 at 07:12

0

You can try thquery.

@Query(value = "{'champsDate':{ $gte: ?0, $lte: ?1}}")
List<entity> findByChampsDateBetween(Date startDate, Date endDate);

answered Sep 17 '18 at 07:12

Yousra ADDALI

2 Answers2