SQL WHERE Clause Examples for Salesforce Restores
Applies to: Record-level restore operations and seeding a sandbox
If the restore operation accepts SQL queries as filters, use the SQL WHERE clause to define the filter.
- Restore a specific set of records by using the 18 character Salesforce ID:
Id IN (‘001f100001W8X5hAAF’, ‘001f100001W8X5hQAE’, ‘001j000000rqIlWAQE’)
- Restore records that were modified during a specific time range:
LastModifiedDate <= '2019-09-14 18:09:51' and LastModifiedDate >= '2019-08-14 18:09:50'
- Restore Account records that were referred by a contact. The filter is applied to the Account object.
Id IN (select AccountId from contact where contact.FirstName = 'jon')
Last modified: 10/15/2019 8:38:49 PM