Salesforce Docs Portal

Data Filters

When you add a data repeater, a data table, or a data function to a page, you don't have to limit the records it retrieves. However, if you're working with a Salesforce object that has thousands of records, you can limit the returned results using filter criteria.

Required Editions

Available in: Salesforce Classic

Available for purchase in: Enterprise, Performance, and Unlimited Editions

Available (with limitations) in: Developer Edition

When you add filter criteria, you must specify:

Filter Operators

Operator Description
Equals Returns an exact match.
Not equal to Returns records that don't have the value you specify.
Less than Returns records that are less than the value you specify.
Greater than Returns records that exceed the value you specify.
Less than or equal to Returns records that match or are less than the value you specify.
Greater than or equal to Returns records that match or exceed the value you specify.
Starts with Use when you know what your value starts with, but not the exact text. For example, “california” would return California Travel, but not Surf California.
Ends with Use when you know what your value ends with, but not the exact text.
Contains Returns records that include your search string but can also include other information. For example, “california” would return California Travel and Surf California.
Includes Use for field types that support multiple values to return records that contain one or more of the comma-separated values you specify.
Includes all Use for field types that support multiple values to return records that contain all of the comma-separated values you specify.
Excludes Use for field types that support multiple values to return records that don't contain one or more of the comma-separated values you specify. For example, for a Locations category field, “San Francisco, Vancouver” would exclude a record containing “San Francisco, Dallas” and a record containing “Vancouver, New York.”
Excludes all Use for field types that support multiple values to return records that don't contain all of the comma-separated values you specify. For example, for a Locations category field, “San Francisco, Vancouver” would exclude only records that contain both terms.

Filter Value Sources

Source Description
Fixed value Use when you want to specify the value.
URL query string Use when you want to pass variable content via a URL to the item when the page loads.
Global property Use when you want to use a fixed value from the site, such as the current date or current time.
Request header Use when you want to use a value from the browser, such as the host header or browser version.
Parent repeater

Use when you want to create a query between unrelated objects, or between content lists or categories. Available only when a data repeater, data table, or data function is nested inside a parent repeater, but the parent repeater's object is unrelated to the nested item's object, and the selected data sources for both are unrelated.

Retrieving data from unrelated objects can adversely affect the performance of your site. We recommend retrieving data from related objects only.

See Also