topic Re: tSalesForceInput Query Using Context Variable in Talend Studio

tSalesForceInput Query Using Context Variable

Anonymous — Sat, 16 Nov 2024 12:25:19 GMT

Dear All,
I tried to use a context variable in a tSalesForceInput query, so the where clause will be dynamic.
Could you help with the right syntax ?
Here is the syntax i have used, but it doesn't wotk.
"select u.Id, u.HermesAgentId__c from User u Where u.HermesAgentId__c = '+ context.GENERIC_AGENT_ID +' "
All the best,
Anzar.

Re: tSalesForceInput Query Using Context Variable

Anonymous — Mon, 30 Jan 2012 01:38:26 GMT

Hi Anzar
Try this.

"select u.Id, u.HermesAgentId__c from User u Where u.HermesAgentId__c = ' "+ context.GENERIC_AGENT_ID +" ' "

Regards,
Pedro

Re: tSalesForceInput Query Using Context Variable

Anonymous — Wed, 15 Aug 2018 18:37:27 GMT

Hi,

I was going through this post and i have used in the below way. I know it is a very old post, just thought of sharing the information.

" SFDCFieldName=\' "+context.VARIABLENAME+" \' "

Thanks,

Goutam