Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to query deleted records on Salesforce

Hi,

I'm trying to use "ALL ROWS" keyword in the Sql code, but it gives me the following error "ALL ROWS not allowed in this context", while using the Salesforce connector.

1 Solution

Accepted Solutions
srchilukoori
Specialist
Specialist

you should use Select_ALL and IsDeleted=True as a condition.

View solution in original post

3 Replies
srchilukoori
Specialist
Specialist

you should use Select_ALL and IsDeleted=True as a condition.

neha_potdar
Contributor
Contributor

Hi,

What about deletes in incremental loads? This solution of IsDeleted = true holds good for full load.

14864011
Contributor
Contributor

Hi is it possible that you be more specific about how to use Select_ALL?  Thank you so much for your help!