> ## Documentation Index
> Fetch the complete documentation index at: https://coconut-grid.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# Searching

export const SALESFORCE_DEVELOPER_BASE_URL = 'https://developer.salesforce.com';

Search records by adding one or more search criteria to the data grid.

## Searching

Create and manage searches from the data grid.

<Steps>
  <Step title="Add a search">
    Drag a column header and drop it into the search drop zone on the data grid.

    Searches are applied with `AND` logic across all active searches.
  </Step>

  <Step title="Edit a search">
    Click the popover icon button on a search box and select **Edit**.

    You can change the field, operator, input type, and other search options.
  </Step>

  <Step title="Change the operator">
    Click the popover icon button on a search box and select **Operators**.

    Available operators depend on the field’s data type.
  </Step>

  <Step title="Change the input type">
    Click the popover icon button on a search box and select **Switch**.

    This option is available only for fields that support multiple input types.
  </Step>

  <Step title="Reorder searches">
    Drag the **Drag** icon button on a search box to reorder searches horizontally.
  </Step>

  <Step title="Disable a search">
    Click the popover icon button on a search box and select **Disable**.
  </Step>

  <Step title="Delete a search">
    Click the popover icon button on a search box and select **Delete**.
  </Step>
</Steps>

## Search Rules

| Field type                                                                                          | Operators                                                                                                                                                | Value input type                    |
| --------------------------------------------------------------------------------------------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------- | ----------------------------------- |
| ID                                                                                                  | equals<br />not equals to                                                                                                                                | Text                                |
| Boolean                                                                                             | equals<br />not equals to                                                                                                                                | Boolean                             |
| Text<br />Encrypted Text<br />Text Area<br />Long Text Area<br />Rich Text Area<br />Phone<br />URL | equals<br />not equals to<br />less than<br />greater than<br />less or equal<br />greater or equal<br />contains<br />does not contain<br />starts with | Text                                |
| Double<br />Long<br />Integer<br />Currency<br />Percent                                            | equals<br />not equals to<br />less than<br />greater than<br />less or equal<br />greater or equal                                                      | Number                              |
| Picklist                                                                                            | equals<br />not equals to<br />less than<br />greater than<br />less or equal<br />greater or equal<br />contains<br />does not contain<br />starts with | Multi-select dropdown<br />Text     |
| Multi-Select Picklist                                                                               | equals<br />not equals to<br />contains<br />does not contain                                                                                            | Multi-select dropdown               |
| Date                                                                                                | equals<br />not equals to<br />less than<br />greater than<br />less or equal<br />greater or equal                                                      | Date picker<br />Date Literals      |
| Date/Time                                                                                           | equals<br />not equals to<br />less than<br />greater than<br />less or equal<br />greater or equal                                                      | Date/Time picker<br />Date Literals |
| Time                                                                                                | equals<br />not equals to<br />less than<br />greater than<br />less or equal<br />greater or equal                                                      | Time picker                         |
| Lookup<br />Master-Detail                                                                           | equals<br />not equals to<br />less than<br />greater than<br />less or equal<br />greater or equal<br />contains<br />does not contain<br />starts with | Lookup search<br />Text             |

<Tip>
  See <a href={`${SALESFORCE_DEVELOPER_BASE_URL}/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql_select_dateformats.htm`} target="_blank">Salesforce Date Literals</a> for supported values.
</Tip>