Searching

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.

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

Search Rules