MongoDB: find records using the date interval calculated from item value

Asked Feb 17 '18 at 20:12

Active Feb 17 '18 at 20:12

Viewed 16 times

I'm trying to achieve the same results as I can get from MySQL query:

select * from items where updated_at + refresh_interval < now()

where updated_at is a BSON\UTCDateTime and refresh_interval is int holding interval in seconds.

for my MongoDB collection. So I probably need $add and Date() functions, but I have hard time to understand where exactly these should be used.

asked Feb 17 '18 at 20:12

Hlorofos

What is your mongo server version ? – s7vr Feb 17 '18 at 20:32
@veeram `db.version() 3.6.2` – Hlorofos Feb 17 '18 at 21:01
1

Try `db.items.find({$expr:{$lt:[{$add:["$updated_at", {$multiply:["$refresh_interval", 1000]}, new Date()]}})` – s7vr Feb 17 '18 at 21:11
1

@chridam, not exactly, but thanks for pointing out for `$expr` operator. I have to add `$multiply: ["$update_interval", 1000]` since my `refresh_interval` is in seconds. – Hlorofos Feb 17 '18 at 21:12

0 Answers0