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

# Search

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

## Search

Open the tab menu, click **Edit**, and select **Search**. Choose fields from **Fields**, configure the selected searches, and click **Save** to save the tab settings.

You can also create and manage searches directly from the data grid as described below.

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

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

### Change the Operator

Click the popover icon button on a search box and select **Operators**.

Available operators depend on the field’s data type.

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

### Reorder Searches

Drag the **Drag** icon button on a search box to reorder searches horizontally.

### Disable a Search

Click the popover icon button on a search box and select **Disable**.

### Delete a Search

Click the popover icon button on a search box and select **Delete**.

## Search Rules

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

> [!TIP]
>
> See [Salesforce Date Formats and Date Literals](https://developer.salesforce.com/docs/platform/salesforce-soql-sosl/guide/sforce-api-calls-soql-select-dateformats.html) for supported values.


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.