Filtering with salesforce.com

Overview

• Filtering with Salesforce.com is much like SQL. It is using salesforce.com's query language called SOQL.
• You can find more information in the "Force.com Web Services API Developer's Guide" - search for SOQL.

 

Examples:

• Filter on Name equal to a specific text:

FIELD NAME	FILTER
Name	Name = 'MYSALE'

 

• Filter on a field being empty (null):

FIELD NAME	FILTER
rapidi__Transferred__c	rapidi__Transferred__c = null

 

• Filter that returns Accounts that have BillingState either California or New York.

FIELD NAME	FILTER
BillingState	BillingState IN ('California', 'New York')

 

• Filter that return anything newer than the date specified:

FIELD NAME	FILTER
CreatedDate	CreatedDate > 2005-10-08T01:02:03Z

 

• Filter that return anything created yesterday:

FIELD NAME	FILTER
CreatedDate	CreatedDate = YESTERDAY

 

• Filter that return anything created during the last week:

FIELD NAME	FILTER
CreatedDate	CreatedDate > LAST_WEEK

 

Please Note: If you are using Source Control when reading from Salesforce.com then all filters are handled by Rapidi as CheckFilter - see Filtering with CheckFilters