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.
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”) + “)”
