IN clause in tSalesforceInput

StevanJovetic10 — Wed, 28 Oct 2020 11:29:06 GMT

Hi all,

i want to use an 'IN' clause in a salesforce input query, based on some data that i already have

I have a list of strings, created runtime based on a csv file, and i want to filter the query in a way that it takes only COLUMN IN (my list of strings) records.

Is it possible to do without using a join?

The problem is that the query as is right now extracts a lot of records and i want to avoid that.

Thanks,

Stevan

Re: IN clause in tSalesforceInput

Anonymous — Wed, 28 Oct 2020 15:40:18 GMT

Hi,

In the job you can store the list of string which you need to use in the filter condition in a global variable, in the tSalesforceInput component under the Basic setting select the Manual Query and enter the SOQL query with where condition

“Select id,name from account where country in (” + (String)globalMap.get(“filterstring”) + “)”

Thanks

topic IN clause in tSalesforceInput in Talend Studio

IN clause in tSalesforceInput

Re: IN clause in tSalesforceInput