Spring data mongo @Query bind date

Question

I have a spring mongo repository with the following method

@Query(value = "{'topicId':{$in: ?0},'ts':{$gt:{$date:?2}, $lte:{$date:?3}}, 'status': {$ne:?4}, 'seen':?1 }")
    public Page<NotificationReference> findByTopicIdInAndSeenAndStatusNot(List<String> topicIds, Boolean seen,
            Date from, Date to, String status, Pageable pageable);

But the ?2 and ?3 date variables are not resolving to their values. I'm passing a java.util.Date to the method, how do I get spring to resolve date variables for mongo queries?

Have you tried to ommit the $date keywords? I mean something like this: @Query(value = "{'topicId':{$in: ?0},'ts':{$gt:?2}, $lte:?3}}, 'status': {$ne:?4}, 'seen':?1 }") — bart.s
– bart.s, Commented Aug 9, 2016 at 20:02

bart.s · Accepted Answer · 2016-08-09 20:13:55Z

1

Not using $date should be enough.

 @Query(value = "{'topicId':{$in: ?0},'ts':{$gt:{$date:?2}, $lte:{$date:?3}}, 'status': {$ne:?4}, 'seen':?1 }")

answered Aug 9, 2016 at 20:13

bart.s

6885 silver badges12 bronze badges

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

Collectives™ on Stack Overflow

Spring data mongo @Query bind date

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related