Guys,
I want to filter the Mongo DB data using insTimeStamp column. below is the sample data.
{
"_id" : ObjectId("5937a5dea2ced9634b7dc390"),
"memberId" : NumberInt(9463),
"transId" : "18733958xx",
"actualCredits" : NumberInt(5),
"currentCredits" : NumberInt(5),
"stamps" : {
"insTimeStamp" : ISODate("2017-06-07T12:36:06.000+0000"),
"updTimeStamp" : ISODate("2017-06-07T12:36:06.000+0000")
},
"expiry" : ISODate("2017-06-10T18:29:59.999+0000")
}
I have used below criteria for the same but getting an error. please guide me on this.
Error: MongoDB Input (3): code FailedToParse: FailedToParse: Bad characters in value: offset:24 of:{ "stamps.insTimeStamp": ISODate("2017-06-07T12:36:06.000+0000") }
Solved! Go to Solution.
Hi @MikeSp
The solution which you provide is worked for me :)
{"stamps.insTimeStamp":{$lte:{$date: "2017-06-16T00:00:00.000+0000"}}}
Thanks for the guidance :)
Need your expertise on one more query, We want to schedule a workflow to pull the data from Mongo DB for last three days without any manual intervention is there any way to do this?