Am I able to use Encrypted Fields in filter criteria in list views, reports and communities? Is there documentation anywhere I can find? I want to verify before rolling out encryption?


There are various limits on listview / reports when using deterministic encryption

In particular, you can not do:

  • Filter on Contains or Starts With or any relative operator (>, < >=, <=)
  • Use the column sort on any encrypted field in a listview (as Order BY is not supported). This does not affect reports, only ListViews

I strongly suggest doing this in a sandbox and testing first.

| improve this answer | |

Yes, if you encrypt a field with deterministic encryption you can filter on that field in list views and reports (and even SOQL if you need).

The documentation for deterministic encryption is here.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.