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

 

  1. Getting Started
  2. Documentation
  3. HowTo
  4. Standard Integrations

 

Service News can now be found on our Product Updates Blog 

 

Remember to Subscribe to our Product Updates Blog to receive updates and product news.

 

 

 

 

Wheeled by Wagn v. 1.9.1