topic tMongoInput Query Parse Error in Talend Studio

tMongoInput Query Parse Error

Anonymous — Wed, 22 May 2019 13:34:54 GMT

i am trying to few records from mongodb collection using below mongo query which is running fine in mongo console or studio3t.

"{
begin_date : {
$gte: new Date(new Date().setDate(new Date().getDate()-30))
}
}"

But it giving the error as

Exception in component tMongoDBInput_3 (All_Tables)
org.bson.json.JsonParseException: JSON reader expected an integer or a string but found 'new'.
	at org.bson.json.JsonReader.visitDateTimeConstructor(JsonReader.java:923)
	at org.bson.json.JsonReader.visitNew(JsonReader.java:554)

Any help.

Re: tMongoInput Query Parse Error

nfz11 — Thu, 23 May 2019 06:30:05 GMT

The are a lot of existing threads on this subject, did you see this one:

https://community.talend.com/t5/Design-and-Development/Selecting-data-from-MongoDB/m-p/61270/highlight/true#M23414

The author in the comment says this syntax worked, for example, to get all records where lastModifiedDate is gte now:

"{lastModifiedDate:
{$gte:{$date:'"+TalendDate.formatDate("yyyy-MM-dd'T'HH:mm:ss.SSS'Z'",new java.util.Date())+"' 
}}}"

Re: tMongoInput Query Parse Error

Anonymous — Mon, 27 May 2019 06:21:39 GMT

Thanks for the reply @nfz11

I did tried what you given.

it's not returning any rows.

[statistics] connecting to socket on port 3702
[statistics] connected
[statistics] disconnected

"{
begin_date:
{
$gte:{$date:'"+TalendDate.formatDate("yyyy-MM-dd'T'HH:mm:ss.SSS'Z'",new java.util.Date())+"' }
}
}"

And how do i can get previous day records from the same.

Re: tMongoInput Query Parse Error

nfz11 — Mon, 27 May 2019 06:56:31 GMT

it's not returning any rows.

[statistics] connecting to socket on port 3702
[statistics] connected
[statistics] disconnected

Do you actually have any data where the begin_date is greater than or equal to today? Try changing gte to lte to see if data is returned to confirm that my suggested syntax works.

You can use the TalendDate.addDate function to change the date. For example, the code below decrements the day by one, e.g. yesterday:

"{
begin_date:
{
$gte:{$date:'"+TalendDate.formatDate("yyyy-MM-dd'T'HH:mm:ss.SSS'Z'",TalendDate.addDate(new java.util.Date(),-1,"dd"))+"' }
}
}"

There is documentation on all the TalendDate functions here:

https://help.talend.com/reader/TakcAFoOnWMPdNo8XXlPpg/mOrhvhXRdRX1oRzaNEkNvw

Although the documentation for the addDate function does not seem correct. It actually takes a Date as an argument but the documentation shows that it takes a date as a string and a format. If you use my addDate example above it will work.