Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Mongo input criteria error

VJ_dup_337
7 - Meteor

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") }

 

Capture.PNG

 

 

1 REPLY 1
VJ_dup_337
7 - Meteor

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?

Labels