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.
1 REPLY
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