Hi Please help me with approach for below implementation.
Adobe Campaign by default does not support all the functions residing in the underlying PostgreSQL database.
Add a custom function to encrypt the input string using AES256 encryption algorithm. PostgreSQL supports this algorithm natively.
You will need to add a new category (‘CC Custom Functions’) and a new function (‘AES Encrypt’) to right-side list of functions of the Advanced Query window.
Configure the input parameters and key values accordingly. Please refer the documentation for more details (the exact steps to add a new custom function are mentioned there).