If a field of CDT is declared as EncryptedText, is it possible to perform query with that field (unencrypted text) as a filtering condition?
Discussion posts and replies are publicly visible
The value is encrypted in the database and is only decrypted when displayed as the value in an EncryptedTextField or within a plug-in using the EncryptionService public API. Therefore, this does not seem possible from queryEntity, nor would you want to allow this functionality from a security perspective if the data is sensitive since people could go fishing for values.
To add on... keep in mind if you are running a query and there is an error, the data will possibly show in the log (defeating purpose of encryption), under certain circumstances. So, I would press you to think through all the places and ways the data could be exposed (unintentionally).
Hope that gives you something to think about.
© 2020 Appian. All rights reserved.