BusinessObjects Board

Pushdown where in clause to Salesforce from SAP BODS 4.2 SP5

Hi Folks,

We are currently working on a project wherein we are extracting data from Salesforce. The jobs are running very long because the where IN clause is not getting pushed down to Salesforce. Is there any alternate way to write this so that filters get pushed down?


S.Diwan (BOB member since 2017-03-01)

You can resolve IN statement to several OR lines:

Example:
WHERE
Field 1 in (v1, v2, v3)

WHERE
Field1 = v1
OR
Field1 = v2
OR
Field1 = v3


barthodo :de: (BOB member since 2012-04-18)