If a field of CDT is declared as EncryptedText, is it possible to perform query with that field (unencrypted text) as a filtering condition?
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.
Discussion posts and replies are publicly visible
© 2020 Appian. All rights reserved.