Help get this topic noticed by sharing it on Twitter, Facebook, or email.

ALL ROWS

I was trying to do an analysis on some of my queries to minimize our API call footprint by using OpenQuery and SOQL.

I keep getting "Error: MALFORMED_QUERY: ALL ROWS not allowed in this context" when trying to use ALL ROWS to get deleted records

The simplest query I tried to run still got the error...
"SELECT * FROM OPENQUERY(SALESFORCEPROD, 'SELECT Id FROM Account ALL ROWS')"

As far as I can tell, my syntax is correct. Am I doing something wrong here?
1 person has
this question
+1
Reply