You need to sign in to do that
Don't have an account?
dai tran 6
How can fillter field is Text (Encrypted)?
Type of field Pass__c is Text (Encrypted):
I create function login:
I create function login:
MyAccount__c accountToUpdate = [SELECT UserName__c FROM MyAccount__c WHERE Status__c=1 and UserName__c=:username and Pass__c=:password LIMIT 1];But it show error:
and UserName__c=:username and Pass__c=:password LIMIT 1 ^ ERROR at Row:1:Column:88 field 'Pass__c' can not be filtered in a query callHow can fillter field is Text (Encrypted)?
IN SOQL/SOSL,
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
https://help.salesforce.com/articleView?id=security_pe_considerations_general.htm&type=0