Use these sample SOQL queries to download Salesforce files based on specific criteria when using Files Downloader for Salesforce.
Thank you for reading this post, don't forget to subscribe!If you want to learn how to use SOQL queries, watch this tutorial video: https://youtu.be/PYx1MYNTJ_0
Date Range Based Queries #
Files uploaded in last 7 days: #
SELECT Id, Name FROM Account WHERE CreatedDate = LAST_N_DAYS:7
Files uploaded in a specific date range: #
SELECT Id, Name, CreatedDate
FROM Account
WHERE CreatedDate >= 2024-01-01T00:00:00Z
AND CreatedDate <= 2024-12-31T23:59:59Z
Files modified this month: #
SELECT Id, Name, LastModifiedDate
FROM Account
WHERE LastModifiedDate = THIS_MONTH
ID-Based Queries #
Files from specific record IDs: #
SELECT Id FROM Account
WHERE Id IN (‘001XXXXXXXX’, ‘001YYYYYYYY’, ‘001ZZZZZZZZ’)
Files from a single Account: #
SELECT Id FROM Account
WHERE Id = ‘001XXXXXXXX’
Relationship Queries #
Files from Contact and related Account (using Account Name): #
SELECT Id FROM Contact
WHERE Account.Name = ‘test’
Files from Contact and related Account (using AccountId): #
SELECT Id FROM Contact
WHERE AccountId = ‘001XXXXXXXX’
Case Object Specific Queries #
Files from Open Cases: #
SELECT Id FROM Case
WHERE IsClosed = false
Files from High Priority Cases: #
SELECT Id FROM Case
WHERE Priority = ‘High’
Files from Cases created in a date range: #
SELECT Id FROM Case
WHERE CreatedDate >= 2024-01-01T00:00:00Z
AND CreatedDate <= 2024-12-31T23:59:59Z
Email attachments from a specific Case: #
SELECT Id, Subject FROM EmailMessage
WHERE ParentId = ‘500XXXXXXXX’ AND HasAttachment = true
Files from Cases owned by a specific user: #
SELECT Id FROM Case
WHERE OwnerId = ‘005XXXXXXXX’
EmailMessage belonging to a Case whose Account matches specific criteria: #
SELECT Id FROM EmailMessage
WHERE Parent.CaseNumber = ‘005XXXXXXXX’
AND Parent.AccountId = ‘00011000XXX’
💡 Pro Tips #
- Replace sample IDs (001XXXXXXXX, etc.) with your actual Salesforce record IDs.
- Adjust date ranges according to your business needs.
- Combine multiple conditions using AND / OR operators for refined filtering.
- Test queries in Salesforce Developer Console before using them in Files Downloader.
