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.

Answer 1

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