Hi Folks,
I want to perform decrypt operation on encrypted fields.
Is there an option to extend the query execution workbench (UI) by implementing custom plug-ins.
Can we change query before giving results on Query Workbench?
Thank you.
Hi,
I could not find any doc related to defining your own functions, I think it is not possible yet. However, I don’t think what you are doing is the right approach, as all values will need to be decrypted in order to be matched and you won’t be able to take advantage of indexing in this scenario.
The best approach would be to actually encrypt the target field and compare the encrypted strings