_ExcerptEncryptedFieldsInFilterAndOrder

Using encrypted fields in filtering and ordering dial lists

When you are configuring filter and sort options you can filter by fields encrypted with deterministic encryption using a limited set of operators.

You cannot sort by fields encrypted with deterministic encryption.

Fields encrypted with probabilistic encryption cannot be used to filter or sort records.

In the following example, a Salesforce administrator has encrypted the Mailing Address field using probabilistic encryption and the Email field using deterministic encryption.

Mailing Address is shown in the field list with the suffix - Encrypted and is disabled.

Email is shown in the field list with the suffix - Encrypted and can be selected. However, only the operators equals and is not are available for use; other operators are not available.