---
schema_version: "1"
id: e40270d526a22d582f45da48d1f71942f281f79cb7b150a6552afd40041b863e
title: Guidelines for Recordset Filter Criteria
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/service/264-0-0/fs_rfc_considerations.md
canonical_url: https://help.salesforce.com/s/articleView?id=service.fs_rfc_considerations.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 44e3bb61a8dbed0ae048e9a2ef286a349be08e152c55f928ad8d058750163093
description: Field Service filter criteria let you match records in one object against records in another. For example, you can choose criteria to filter which service appointments can be scheduled during a shift.
products:
  - Field Service
release: "264"
---
# Guidelines for Recordset Filter Criteria

Field Service filter criteria let you match records in one object against records in another. For example, you can choose criteria to filter which service appointments can be scheduled during a shift.

### 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: Lightning Experience</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">The Field Service core features, managed package, and mobile app are available in <strong>Enterprise</strong>, <strong>Unlimited</strong>, and <strong>Developer</strong> Editions.</td></tr></tbody></table>

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small permission">
      <colgroup>
        <col style="width:50%">
        <col style="width:50%">
      </colgroup>
      <thead class="slds-text-title_caps ">
        <tr class="">
          <th scope="colgroup" class="slds-cell-wrap" colspan="2" style="text-align:center;vertical-align:top;" id="d96934e70">User Permissions
            Needed</th>
        </tr>
      </thead>
      <tbody>
        <tr class="">
          <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d96934e70 ">To view, create, and update recordset filter criteria for shifts</td>

          <td class="slds-cell-wrap" style="vertical-align:top;" headers="d96934e70 ">
            <p>View, create, and edit on Recordset Filter Criteria and Recordset Filter Criteria
              Rules</p>
            <p>AND</p>
            <p>View on the filtered object, source object, and filtered object’s fields</p>
            <p>AND</p>
            <p style="margin-bottom:0;">Delete on Recordset Filter Criteria Rules</p>
          </td>

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

## Recordset Filter Criteria Considerations

Keep these considerations in mind when you create and edit recordset filter criteria.

- Only Recordset Filter Criteria marked Active are used in scheduling.
- When you add multiple filter conditions, only appointments matching all the conditions can be scheduled.
- The Value input changes depending on the service appointment field you choose. For example, picklist fields show the list of available choices.
- You can’t match on text field values that include apostrophes (`’`), commas (`,`), or double quotation marks (`”`).
- Users without access to a service appointment field used in a filter condition don’t see the field name or value. They also can’t edit or delete the filter condition.
- When you use inline edit on a recordset filter criteria, the filter conditions are shown in the related list. You can manage filter conditions individually from the related list. Or to see all the filter conditions in one place, use the Edit action.
- The Recordset Filter Criteria field must be added to the Shift page layout.
- After you add a custom field to the filtered object, it can take around 15 minutes for the new field to appear in the Criteria Field picklist.
- You can add a maximum of 5 considerations to the Recordset Filter Criteria field.
- The asset fields Availability, Reliability, Average Time to Repair, and Average Time Between Failures are calculated internally, so they can’t be used to define Usage-Based, Usage-Counter, or Usage-Duration rule types.

## Guidelines for Custom Logic

- Build the filter logic with parentheses and the AND or OR Boolean operators. To group conditions, use parentheses around the parameters, for example 1 AND (2 OR 3). If you add another condition, the custom logic is updated automatically to 1 AND (2 OR 3) AND 4.
- Every index must have a corresponding recordset filter criteria rule, but every rule doesn’t need to be used in the custom logic.
- If no custom logic is defined, all recordset filter criteria rules are treated with an AND, meaning all conditions must be True.
- You can’t delete a recordset filter criteria rule that’s referenced in custom logic. Alternatively, you can follow these steps:
    1. Update RFC.CustomLogic as empty, or remove the index reference in custom logic.
    2. Delete the recordset filter criteria rule.
    3. Update RFC.CustomLogic with the correct value.

#### See Also

- [Field Service Guidelines for Shift Availability](https://help.salesforce.com/s/articleView?id=service.fs_shifts_guidelines.htm&release=264.0.0&type=5 "Learn how to define valid shifts and show when your workers are available for shift work. Shifts can work alone or alongside operating hours and service territory memberships to define workforce availability. Designate shifts to show availability for specific types of work or tasks, or for specific territories. For example, you can designate an on-call shift for emergency appointments only.")
- [Define Which Appointments Can Be Scheduled During Shifts](https://help.salesforce.com/s/articleView?id=service.fs_rfc_create.htm&release=264.0.0&type=5 "Similar to how you use designated time slots on operating hours, in Field Service, you can use Record set Filter Criteria to define and designate which appointments can be scheduled to service resources during shifts. Create Recordset Filter Criteria based on service appointment field values, and then add the filter to a shift so that only relevant appointments get scheduled.")