Searching
Create and manage searches from the data grid.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.
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 |