filter query doesn't work for Platform Encryption

Question

i'm trying to perform Platform Encryption on contact fields : Phone, Fax, Email

But i'm trying to filter MobilePhone in query

SELECT MobilePhone FROM Contact WHERE MobilePhone != null

getting following error :

encrypted field 'MobilePhone' cannot be filtered in a query call
you can click here for help

Did you double check that you did not encrypted MobilePhone? Also do you have person account enabled? — Tushar Sharma, Dec 20, 2016 at 5:58
MobilePhone is encrypted , thats why the error is and it is nothing to do with person account — Santanu Boral, Dec 20, 2016 at 6:01
yes i had checked it many time i had tried: sObjectType.Contact.fields.MobilePhone.isEncrypted() it gives false — Ashwani Kumar, Dec 20, 2016 at 6:37

Santanu Boral · Accepted Answer · 2016-12-20 06:14:29Z

1

We cannot use long text area field, encrypted data field, or base64-encoded field in WHERE condition in SOQL or SOSL statement.

answered Dec 20, 2016 at 6:14

Santanu Boral

35.9k8 gold badges40 silver badges71 bronze badges

Add a comment |

1 Answer 1