BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: No events within the next 45 days.

Pushdown where in clause to Salesforce from SAP BODS 4.2 SP5


 
Search this topic... | Search DI: Performance and Tuning... | Search Box
Register or Login to Post    Forum Index -> Data Integrator -> DI: Performance and Tuning  Previous TopicPrint TopicNext Topic
Author Message
S.Diwan
Forum Member
Forum Member



Joined: 01 Mar 2017

Posts: 1



PostPosted: Wed Mar 01, 2017 7:21 am 
Post subject: 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?
Back to top
barthodo
Principal Member
Principal Member



Joined: 18 Apr 2012

Posts: 231
Location: Munich


flag
PostPosted: Tue Nov 14, 2017 2:57 am 
Post subject: Re: Pushdown where in clause to Salesforce from SAP BODS 4.2

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
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Data Integrator -> DI: Performance and Tuning  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0266 seconds using 17 queries. (SQL 0.0027 Parse 0.0008 Other 0.0230)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo