Page Comparison

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.

Image Added

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

Image Added

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.

Image Added