October 20, 2019

Field can not be filtered in a query call Salesforce

1. Check whether it is Text(Encrypted) field since it cannot be used.


Encrypted fields that use the probabilistic encryption scheme can’t be used with the following SOQL and SOSL clauses and functions:
Aggregate functions such as MAX(), MIN(), and COUNT_DISTINCT()
WHERE clause
GROUP BY clause
ORDER BY clause

2. You can't filter by text area fields in SOQL.

No comments:

Post a Comment