tSalesForceInput Query Using Context Variable

[Anonymous]

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.

[Anonymous]

Hi Anzar
Try this.

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

Regards,
Pedro

[Anonymous]

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