Filter Operators
The operator in a filter is like the verb in a sentence. Operators specify how filter criteria relate to each other. Refer to this list of filter operators when setting filters on actionable list members or prospects.
Required Editions
| Available in: Lightning Experience |
| Available in: Enterprise, Professional, Starter, and Unlimited Editions with the required add-ons |
| Operator | Uses |
|---|---|
| Equals | Use for an exact match. For example, “Billing Country equals US.” |
| Less than | Use for results that are less than the value you enter. For example, “Quota less than 20000” returns records where the quota field ranges from 0 to 19,999.99. |
| Greater than | Use when you want results that exceed the value you enter. For example, “Quota greater than 20000” returns records where the quota amount begins at 20,000.01. |
| Less or equal | Use for results that match or are less than the value that you enter. |
| Greater or equal | Use for results that match or exceed the value that you enter. |
| Not equals | Shows results that don’t have the value that you enter. This operator is useful for eliminating empty fields. For example, “Email not equal to <blank>.” If evaluating more than one value, none of the specified values can exist on the record. For example, if you specify not equal to A & C, only records where the value is neither A nor C are returned. |
| Contains | Use for fields that include your search string, but sometimes also include other information. For example, “Account contains California” finds California Travel, California Pro Shop, and Surf California. Keep in mind that if you enter a short search string, it can match a longer word. For example, “Account contains pro” finds California Pro Shop and Promotions Corporation. This operator isn’t case-sensitive except when it's used in roll-up summary (RSF) field filters. For example, you have this filter criteria for an RSF field: Opportunity name contains widgets. The query that creates the RSF field value only returns records with a name value that contains widgets. Records with name values that contain Widgets or WIDGETS aren’t included. |
| Starts with | Use when you know what your value starts with, but not the exact text. This operator is a narrower search term than “contains.” For example, if you enter “Account starts with California,” you find California Travel and California Pro Shop, but not Surf California. |
この記事で問題は解決されましたか?
ご意見をお待ちしております。
