---
title: SOQL Query Samples for Exporting Files in Salesforce
description: "Use these sample [SOQL queries to download Salesforce files](https://www.filesdownloader.us/export-mass-files-from-salesforce-soql-query/) based on specific criteria when using [**Files Downloader for Salesforce**](https://appexchange.salesforce.com/appxListingDetail?listingId=a0N4V00000HEWTBUA5&tab=e).  Thank you for reading this post, don't forget to subscribe! If you want to learn how to use SOQL queries, watch…"
url: "https://www.filesdownloader.us/docs/soql-query-samples/"
updated: "2025-12-10"
category: All About Filesdownloader
---

# SOQL Query Samples for Exporting Files in Salesforce

Use these sample [SOQL queries to download Salesforce files](https://www.filesdownloader.us/export-mass-files-from-salesforce-soql-query/) based on specific criteria when using [**Files Downloader for Salesforce**](https://appexchange.salesforce.com/appxListingDetail?listingId=a0N4V00000HEWTBUA5&tab=e). 

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](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](https://help.salesforce.com/s/articleView?id=000385008&language=en_US&type=1).
- Adjust date ranges according to your business needs.
- Combine multiple conditions using AND / OR operators for refined filtering.
- Test queries in [**Salesforce Developer Console**](https://help.salesforce.com/s/articleView?id=platform.code_dev_console.htm&type=5) before using them in **Files Downloader**.