topic Re: issue concatenating query with context in tMongoDBInput in Talend Studio

issue concatenating query with context in tMongoDBInput

Anonymous — Sat, 16 Nov 2024 11:06:30 GMT

Hi,
There is an issue in Talend 6.0.0 that seems not to appear in previous versions. We get a compile error when we concatenate a context variable in the query in MongoInput. The exact same job compiled ok in previous versions of talend.
Please see the attached screenshots and job itself. Looking at the code it seems that the query is interpreted as a regex, which is not.

Talend.zip_20150805-2250.zip

Re: issue concatenating query with context in tMongoDBInput

Anonymous — Fri, 14 Aug 2015 10:06:26 GMT

Hi tamax,

How did you set your schema of tMongoDBInput? Can you use a simple query (without context) in tMongoDBInput to see if it is working well?

Best regards
Sabrina

Re: issue concatenating query with context in tMongoDBInput

Anonymous — Fri, 14 Aug 2015 15:23:04 GMT

Hi Sabrina,
Yes, the exact same query works if I replace the context variable by its value.

Re: issue concatenating query with context in tMongoDBInput

Anonymous — Fri, 21 Aug 2015 16:16:37 GMT

Hi Sabrina, could you check on this? The job is attached to the first post.

Re: issue concatenating query with context in tMongoDBInput

_AnonymousUser — Wed, 20 Jan 2016 11:51:28 GMT

Hi,
Im also facing the same issue, im not able to use context variable in mongo query using tmongoinput component.
Im using the below query and trying to extract data above certain date limit
"{'_createdAt': { $gte :{$date:'"+context.incrementaldate1+"'}}}"
But im getting error like
Type mismatch: cannot convert from String to Boolean

Re: issue concatenating query with context in tMongoDBInput

Anonymous — Wed, 20 Jan 2016 13:32:46 GMT

Hi Chakravarthy,
I reported this bug already on Jira and it has been fixed by Talend team. It will be available on the next version:
https://jira.talendforge.org/browse/TBD-2964

Best regards,
Maxime