MongoDB Query Dynamic Date Range?

JacobFolsom
JacobFolsom Domo Employee
in Archive

Is anyone aware of a method to write a MongoDB query for a dynamic date-range? 

 

I found this link online, and tried the code below, but it does NOT work in the connector:

...
"order_date" : { 
$lt: new Date(), 
$gte: new Date(new Date().setDate(new Date().getDate()-1))
}

 

Any thoughts on how we can do something like this in the connector?

Jacob Folsom
**Say “Thanks” by clicking the “heart” in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"

Comments

  • JSturm
    JSturm Member

    I know this question is very old, but I had a similar problem and solved it with an aggregation pipeline. Note, this requires MongoDB 4.2 or later.

    {$expr: {$gt: ["$order_date", {$subtract: ['$$NOW', 24*60*60*1000]}]}}

    This compute an "age" field that I can then filter on. I don't know if there's a simpler way but this worked for me.

    I also defined this pipeline in a MongoDB view and queried the view from Domo, using the simpler "Find" method. It's easier to manage complex pipelines outside of Domo. But whether you do that is your choice.

Categories