Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Excerpt

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.

Encrypted fieldsImage Added

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

Filter by encrypted fieldImage 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