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 · Accepted Answer · 2017-04-29 18:44:58Z

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);

answered Apr 29, 2017 at 18:39

s7vr

76.2k12 gold badges118 silver badges135 bronze badges

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

2 Comments

the @Query solution solves my problem, thanks a lot!!

Is there a way to have this work while also including additional criteria to filter on?

Yousra ADDALI · Accepted Answer · 2018-09-17 07:12:38Z

0

You can try thquery.

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

answered Sep 17, 2018 at 7:12

Yousra ADDALI

4321 gold badge4 silver badges15 bronze badges