topic Re: tDbMongoInput ParseError for Query in Talend Studio

tDbMongoInput ParseError for Query

Anonymous — Fri, 01 Feb 2019 14:32:30 GMT

I want to find record from mongo by date , So i write one query

"{\"date\":{\"$gte\":\"ISODate(\"" + globalMap.get("max_QueryUpdatedAt") + "\")\"}}"

it giving the parseError

Re: tDbMongoInput ParseError for Query

vapukov — Sat, 02 Feb 2019 08:43:43 GMT

@maheep6776 wrote:

I want to find record from mongo by date , So i write one query

"{\"date\":{\"$gte\":\"ISODate(\"" + globalMap.get("max_QueryUpdatedAt") + "\")\"}}"

it giving the parseError

Hi,

what the full error text?

btw, try this:

"{\"date\":{\"$gte\":\"ISODate(\"" + (String)globalMap.get("max_QueryUpdatedAt") + "\")\"}}"

Re: tDbMongoInput ParseError for Query

Anonymous — Sat, 02 Feb 2019 15:30:41 GMT

I want this mongo query in TalendEtl tmongoDbInput,
{"date" : {$gte:ISODate("2019-01-03T09:56:11.244Z")}})

I used globalMap.get("max_QueryUpdatedAt") for storing date
and i m getting following error , I have tried your Query
"{\"date\":{\"$gte\":\"ISODate(\"" +
(String)globalMap.get("max_QueryUpdatedAt") + "\")\"}}"

I am attaching error Screen Shot
Code generated by Talend
com.mongodb.DBObject myQuery = (com.mongodb.DBObject) com.mongodb.util.JSON
.parse("{\"date\":{\"$gte\":\"ISODate(\""
+ (String) globalMap.get("max_QueryUpdatedAt")
+ "\")\"}}");

Re: tDbMongoInput ParseError for Query

Anonymous — Tue, 05 Feb 2019 06:12:14 GMT

Screenshot from 2019-02-02 20-57-08.png

Re: tDbMongoInput ParseError for Query

vapukov — Tue, 05 Feb 2019 06:31:34 GMT

@maheep6776 wrote:

I want this mongo query in TalendEtl tmongoDbInput,
{"date" : {$gte:ISODate("2019-01-03T09:56:11.244Z")}})
and i m getting following error , I have tried your Query
"{\"date\":{\"$gte\":\"ISODate(\""+(String)globalMap.get("max_QueryUpdatedAt") + "\")\"}}"

as you could see you have a difference in query code, what you want and what you send

try this

"{\"date\":{$gte:ISODate(\""+(String)globalMap.get("max_QueryUpdatedAt") + "\")}}"

P.S. keep in mind - here not a mongodb forum, and I not a MongoDB queries expert 🙂

so, I could only suggest proper check Java syntax

Re: tDbMongoInput ParseError for Query

Anonymous — Tue, 05 Feb 2019 07:02:11 GMT

Thanks For your Reply. It is working fine now . I m really sorry for typos mistake.

Re: tDbMongoInput ParseError for Query

vapukov — Tue, 05 Feb 2019 07:08:15 GMT

it not a problem at all!

welcome to community!