Skip to main content
All CollectionsHistorical ArchiveExcel Data Management for SalesforceTroubleshooting
Troubleshooting: CloudExtend Excel for Salesforce does not allow me to filter based on the record type
Troubleshooting: CloudExtend Excel for Salesforce does not allow me to filter based on the record type

XLSF | CloudExtend Excel can leverage a SOQL statement to filter on record types

Updated over 3 months ago

Record type does not display in the data filter as criteria that can be used during download operations. This is because it is not something common across all objects and is specific to the user’s account. 

No need to give up here though. We allow you to modify the WHERE clause of the SOQL statement. See this article for more info on creating SOQL queries with CloudExtend Excel for Salesforce.

💡 Pro Tip: Name the template appropriate to the action you are performing (ie: Lead template with SOQL).

Example of SOQL statement:(using Lead as example object) 

SELECT Id, Name FROM Lead Where RecordType.Name='Lead Record Type'

Users can just edit the Where Clause to include the RecordType name condition.

Did this answer your question?