• Salesforce® Discussions

  Which SOQL statement can be used to get all records even from recycle bin or Achieved Activities in Salesforce?

  Posted by Aman on September 22, 2018 at 6:24 PM

  Which SOQL statement can be used to get all records even from recycle bin or Achieved Activities in Salesforce?

  Parul replied 7 years, 7 months ago 3 Members · 2 Replies

  • AccountId
  • Achieved Activity
  • ALL ROWS
  • Code Snippet
  • Recycle Bin
  • Salesforce Opportunity
  • Salesforce SOQL
• 2 Replies

• 

  shariq

  Member

  September 22, 2018 at 6:25 PM

  We will need “ALL Rows” clause of SOQL.
  Sample:

  SELECT COUNT() FROM Contact WHERE AccountId = a.Id ALL ROWS

• [adinserter block='9']
• 

  Parul

  Member

  September 23, 2018 at 6:21 AM

  SELECT COUNT() FROM OPPORTUNITY WHERE AccountId = a.Id ALL ROWS