We have a filter in our multi-step report that is looking for specific Account records. This record was recently created about a month ago. When we try to find that account in one of the filters, we get the following error message:
INVALID_QUERY_FILTER_OPERATOR:
Name , Id From Account where Name like '%florida%' order by Id
^
ERROR at Row:1:Column:38
The operator like is not supported on an encrypted field
sfdcService: get Account get-Account-121
soql was:
Select Name , Id From Account where Name like '%florida%' order by Id asc limit 201"
Other Accounts that were created long ago don't have any issues being pulled into the report. But for whatever reason, this newish Account can't get searched for in the filter without being hit with the error message. We've cleared caches for the entire org, and unfortunately, that didn't resolve the issue for myself (a sys admin) and our users.
Any help into the error message would be much appreciated!
#Apsona
Hi,
The error occurs because the
Account Name field is encrypted with Shield Platform Encryption (deterministic encryption), which does not support the LIKE operator in SOQL. Older Accounts may still work because they were created before encryption was enabled, but newer ones are fully encrypted, causing the query to fail. Clearing cache won’t help since it’s a platform limitation. To resolve this, you’ll need to either remove/change encryption on the Name field, avoid using LIKE and switch to exact matches (=), or create a separate non-encrypted text field (e.g., “Search Name”) to use for partial searches in reports.
