topic Re: Bug : How to make Aggregation Pipeline Query with tMongoDBInput component ? in Talend Studio

Bug : How to make Aggregation Pipeline Query with tMongoDBInput component ?

Anonymous — Mon, 29 May 2017 11:27:26 GMT

Hi,

I have a tMongoDBInput component, and i want to use a query type : "Aggregation Pipeline Query".

When in put a line with my request in the tab "Aggregation stages", (see code snippet below), i have lot of errors / Syntax errors. how can i solve the problem ? thanks.

Code MongoDB Request Snippet :

db.lines.find({$and:[{'type':{$in:['id']}},
{'processus_time':{$gte: new Date(new Date("2017-05-28T16:00:00Z").setHours(0,0,0,0)).toISOString()}},
{'processus_time':{$lte: new Date(new Date().setHours(23,59,59,999)).toISOString()}},
{'a':null}]})

Re: Bug : How to make Aggregation Pipeline Query with tMongoDBInput component ?

vapukov — Mon, 29 May 2017 12:42:30 GMT

try this:

"db.lines.find({$and:[{'type':{$in:['id']}},
{'processus_time':{$gte: new Date(new Date(\"2017-05-28T16:00:00Z\").setHours(0,0,0,0)).toISOString()}},
{'processus_time':{$lte: new Date(new Date().setHours(23,59,59,999)).toISOString()}},
{'a':null}]})"

double quotes around query and escape \ for internal quotes

Re: Bug : How to make Aggregation Pipeline Query with tMongoDBInput component ?

Anonymous — Mon, 29 May 2017 13:19:03 GMT

thanks for your response. i tried this (copy paste), and i have now :

Talend Error : String literal is not properly closed by a double quote.

Re: Bug : How to make Aggregation Pipeline Query with tMongoDBInput component ?

vapukov — Mon, 29 May 2017 13:21:42 GMT

please attach screenshot, because it work

2 pair of eyes better than 1 😉

Re: Bug : How to make Aggregation Pipeline Query with tMongoDBInput component ?

Anonymous — Mon, 29 May 2017 13:25:08 GMT

Re: Bug : How to make Aggregation Pipeline Query with tMongoDBInput component ?

Anonymous — Tue, 30 May 2017 07:15:46 GMT

Re: Bug : How to make Aggregation Pipeline Query with tMongoDBInput component ?

vapukov — Tue, 30 May 2017 13:22:37 GMT

what is error text?

not seen - wha component return error? not seen full text in window