Loading
Extend Salesforce with Clicks, Not Code
Table of Contents
Filter by (0)Add
Select Filters

          No results
          No results
          Here are some search tips

          Check the spelling of your keywords.
          Use more general search terms.
          Select fewer filters to broaden your search.

            Search all of Salesforce Help
            Search all of Salesforce Help
            Data Filters

            You are here:

            1. Salesforce Help
            2. Docs
            3. Extend Salesforce with Clicks, Not Code

            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

             
            Loading
            Salesforce Help | Article