tSalesForceInput Query Using Context Variable

One Star

tSalesForceInput Query Using Context Variable

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.
One Star

Re: tSalesForceInput Query Using Context Variable

Hi Anzar
Try this.
"select u.Id, u.HermesAgentId__c from User u Where u.HermesAgentId__c = ' "+ context.GENERIC_AGENT_ID +" ' "

Regards,
Pedro
Four Stars

Re: tSalesForceInput Query Using Context Variable

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