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

Using _QueryAll

I am querying OpportunityLineItem_QueryAll for a deleted Id. When I used DBAmp I do not get any results for that Id. When I use the GetDeleted API call directly I see that Id in my result list.

Why doesn't the Id come back in the _QueryALL? Am I misunderstanding how the _QueryAll really works?

Eric
1 person has
this question
+1
Reply
  • In the salesforce api doc there are several places where the doc states that the get deleted api call should be used instead of the queryall api call to detect deleted records. It is not clear in the documentation if the internal sources of these 2 calls are different.

    Are you able to do a QueryAll with your other tool to see if the QueryAll call is consistent between all the tools (in that the deleted record does not appear).

    Also, make sure you are using the exact same sf user for both tools as sf security rules can affect the results of the api call.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. kidding, amused, unsure, silly happy, confident, thankful, excited sad, anxious, confused, frustrated indifferent, undecided, unconcerned

  • Thanks for the quick answer Bill.

    I wrote some code to do an API call to queryAll for the object. The Ids did not come back from that either just like dbamp call to queryAll.

    So there is no problem with DBamp.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. kidding, amused, unsure, silly happy, confident, thankful, excited sad, anxious, confused, frustrated indifferent, undecided, unconcerned