This error occurs because the search query is retrieving more than 50,000 records, which exceeds the system limit. The Accounts object typically contains a larger number of records compared to Opportunities, which is why you may not encounter this issue on Opportunities.
To resolve this, refine your record search criteria:
- Use List View Filters:
- In Salesforce, create a List View and apply filters like a specific Created Date range to reduce the number of results.
- Use Advanced Search(SOQL) Query for Filtering:
- If using SOQL, apply filters to restrict the records being queried. Example:
CreatedDate >= 2024-01-01T00:00:00Z
AND CreatedDate <= 2024-12-31T00:00:00Z - Ensure the date format follows
YYYY-MM-DDThh:mm:ssZ.
- If using SOQL, apply filters to restrict the records being queried. Example:
- Refer to the Advanced Search Guide:
- For a detailed step-by-step guide on filtering parent records within a specific date range and downloading related files & attachments, please refer to our FAQ article: How to search for parent records of a specific date range of files & attachments to download using the Advanced Search (SOQL) option?
PS: View Mass File Download, Salesforce file download app on Salesforce AppExchange: https://appexchange.salesforce.com/appxListingDetail?listingId=a0N3A00000EcsAOUAZ