I tried querying a Encrypted field in SOQL. Gives an error: encrypted field 'Email' cannot be filtered in a query call
Can i achieve it using SOSL??
Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. It only takes a minute to sign up.Sign up to join this community
Yes, see the Key limitations and their workarounds documentation.
You can use SOSL with an
IN EMAIL FIELDS to get down to a small set of results and then an Apex look to refine to just the
Note that unit tests become more awkward because SOSL's index isn't built so you have to nominate the Id(s) that will be returned using