-
How to get all Salesforce records even from recycle bin or Achieved Activities using SOQL query?
How to get all records even from recycle bin or Achieved Activities using SOQL query?
-
1 Reply
-
Hi Saurabh,
Simply use the ALL ROWS clause.
SELECT Id, isDeleted FROM <Oblectname> WHERE isDeleted = true All ROWS – This will only return the deleted rows.
SELECT Id, isDeleted FROM <Oblectname> WHERE isArchived = true All ROWS – This will only return the archived rows.
SELECT Id, isDeleted FROM <Oblectname> All ROWS – This will return the deleted records, archived records and records that are neither deleted nor archived (data set identical to the one returned by a SOQL not using ALL ROWS) as well.
Log In to reply.
Popular Salesforce Blogs
Increase your sales and boost your profits with the power of QuickBooks and Salesforce
Today’s digital-savvy and well-informed customers demand superlative and personalized customer service from every brand they interact with. They expect brands to know their preferences and…
Introducing ForceGPT: Bringing Conversational AI Into Your Salesforce Experience
In today’s fast-paced business environment, success is no longer just about data and dashboards — it’s about how intuitively users can tap into that data…
Syncing Articles from Zendesk Knowledge Base to Salesforce Knowledge – A Success Story
Customers need excellent support with minimal human interaction. That’s why they prefer self-service. And to keep customers hooked to your product, you need to give…
Popular Salesforce Videos
Create and Format Derived Measures
In the explorer, you can perform calculations on existing measures and use the results to create a new measure that’s not part of your dataset.…
Getting started with salesforce
Salesforce is a customer relationship management solution that brings companies and customers together. It's one integrated CRM platform that gives all your departments — including…
Prepopulate Field values in Salesforce Lightning Experience Using defaultFieldValues
Prepopulate Field values in Lightning Experience Using defaultFieldValues - Spring 20 This video demonstrates the following items: Set Record Type Id Using defaultFieldValues Enforce User…
