---
schema_version: "1"
id: 4c32bacc00d5432a658cb509c9f83d6a6ca6d35de0f1b3a494ca504b4eb12b02
title: Data Filters
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/platform/264-0-0/siteforce_data_operators.md
canonical_url: https://help.salesforce.com/s/articleView?id=platform.siteforce_data_operators.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: ff022ac4ead65ed5fad7f6a7a5b09c3626615c53dc4e0cac534d9ac9b7cf347c
description: 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.
products:
  - Salesforce Platform
  - Security
release: "264"
---
# 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

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small edition">
      <colgroup>
        <col>
      </colgroup>
      <tbody>
        <tr class="">
          <td class="slds-cell-wrap" style="vertical-align:top;">Available in: Salesforce Classic</td>

        </tr>
        <tr class="">
          <td class="slds-cell-wrap" style="vertical-align:top;">
            <p>Available for purchase in: <strong>Enterprise</strong>, <strong>Performance</strong>, and
              <strong>Unlimited</strong> Editions
            </p>
            <p style="margin-bottom:0;">Available (with limitations) in:
              <strong>Developer</strong> Edition
            </p>
          </td>

        </tr>
      </tbody>
    </table>

When you add filter criteria, you must specify:

- The field to which the filter criteria apply
- The operator
- [The source of the filter value](https://help.salesforce.com/s/articleView?id=platform.siteforce_data_operators.htm&release=264.0.0&type=5)
- The filter value

## 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

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small ">
        <colgroup>
          <col style="width:28.57142857142857%">
          <col style="width:71.42857142857143%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d37198e255">Source</th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d37198e258">Description</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="Source" class="slds-cell-wrap" style="vertical-align:top;" headers="d37198e255 ">Fixed value</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d37198e258 ">
              <span id="siteforce_data_operators__siteforceFixed"><a name="siteforce_data_operators__siteforceFixed"><!-- --></a>Use when you want to specify the
                value.</span>
            </td>

          </tr>
          <tr class="">
            <td data-label="Source" class="slds-cell-wrap" style="vertical-align:top;" headers="d37198e255 ">URL query string</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d37198e258 ">
              <span id="siteforce_data_operators__siteforceQuery"><a name="siteforce_data_operators__siteforceQuery"><!-- --></a>Use when you want to pass variable
                content via a URL to the item when the page loads.</span>
            </td>

          </tr>
          <tr class="">
            <td data-label="Source" class="slds-cell-wrap" style="vertical-align:top;" headers="d37198e255 ">Global property</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d37198e258 ">
              <span id="siteforce_data_operators__siteforceGlobal"><a name="siteforce_data_operators__siteforceGlobal"><!-- --></a>Use when you want to use a fixed value
                from the site, such as the current date or current
                time.</span>
            </td>

          </tr>
          <tr class="">
            <td data-label="Source" class="slds-cell-wrap" style="vertical-align:top;" headers="d37198e255 ">Request header</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d37198e258 ">
              <span id="siteforce_data_operators__siteforceRequest"><a name="siteforce_data_operators__siteforceRequest"><!-- --></a>Use when you want to use a value from
                the browser, such as the host header or browser
                version.</span>
            </td>

          </tr>
          <tr class="">
            <td data-label="Source" class="slds-cell-wrap" style="vertical-align:top;" headers="d37198e255 ">Parent repeater</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d37198e258 ">
              <p>
                <span id="siteforce_data_operators__siteforceParent"><a name="siteforce_data_operators__siteforceParent"><!-- --></a>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.</span>
              </p>
              <p style="margin-bottom:0;" id="siteforce_data_operators__siteforceParentNote"><a name="siteforce_data_operators__siteforceParentNote"><!-- --></a>Retrieving data from unrelated objects
                can adversely affect the performance of your site. We recommend
                retrieving data from related objects only.</p>
            </td>

          </tr>
        </tbody>
      </table>

#### See Also

- [Dynamically Retrieve Data with Data Repeaters](https://help.salesforce.com/s/articleView?id=platform.siteforce_data_repeater.htm&release=264.0.0&type=5 "Use a data repeater to connect to a standard or custom Salesforce object and retrieve a dataset based on the filter criteria that you specify.")
- [Dynamically Retrieve Data with Data Tables](https://help.salesforce.com/s/articleView?id=platform.siteforce_data_table.htm&release=264.0.0&type=5 "Use a data table to connect to a standard or custom Salesforce object, retrieve a dataset based on the filter criteria that you specify, and display one or more record as rows in the table.")
- [Using Data Functions](https://help.salesforce.com/s/articleView?id=platform.siteforce_data_function.htm&release=264.0.0&type=5 "A data function lets you connect to a standard or custom Salesforce object, perform calculations on the returned results, and display the calculation on the page. For example, for a particular field in an object, you can use a data function to calculate the total value or the average amount of all returned records.")
- [About Displaying Dynamic Data Using Expressions](https://help.salesforce.com/s/articleView?id=platform.siteforce_data_merge_fields.htm&release=264.0.0&type=5 "Site.com uses expression language to display data dynamically. Expressions serve as placeholders for data that is replaced with information when the page loads. When working with data-bound page elements or custom widget properties, you can use expressions to customize how data is displayed on the page.")