Date Range Query Param in MongoDB Query

Support Self Hosted Redash Support
,
1

Issue Summary

I have managed to get the date range param up but it doesn’t do anything yet. I want the data range selected to apply to the createdAt filed. I am not too sure how to do that.

Screenshot 2022-03-28 at 9.28.16 AM
Screenshot 2022-03-28 at 9.28.16 AM2136×822 66.9 KB

2

I changed
"query":{}
to
"query":{"createdAt":{"$gt":{"humantime":"{{ DATE RANGE.start }}:00:00"},"$lt":{"humantime":"{{ DATE RANGE.end }}:00:00"}}},

Then the whole table goes blank. Am I missing something?

3

Hi there and welcome to the forum. Your query doesn’t look like it meets the requirements of the MongoDB query runner. Look at the Querying MongoDB Documentation and follow-up if you have further issues.