Encrypt Password (2 Way Encrypted) field value

[naveenreddy0871]

Hi team,

How can we encrypt a value in a Password (2-Way Encrypted) field?

The field resides in a table that belongs to the XXX application scope, and the encryption is required during the execution of a Transform Map associated with a specific data source that exists in the Global application scope.

I attempted to create a cross-scope privilege to allow access between the applications. However, the system does not allow me to select Global as the source scope while configuring the privilege.

Could you please advise on the recommended approach for encrypting the field value in this scenario and handling the cross-scope access requirements?

Thanks

[Ankur Bawiskar · Accepted solution]

@naveenreddy0871 

what's your exact business requirement?

[naveenreddy0871]

Hi Ankur ,

Thanks for the response.

Requirement:

We have a scoped application containing the sn_fin_supplier_payment table, where the account_number field is stored as a "Password (2 Way Encrypted)" field. We are running a system import through a Transform Map in the Global application that imports incoming bank account information.

As part of the transformation process, we need to compare the incoming account number with existing account numbers in the sn_fin_supplier_payment table to prevent the creation of duplicate records.

Issue:

1. When executing the decryption logic (getDecryptedValue()) within the Transform Map, the system is unable to read the account number because the field resides in a scoped application. How can we access and decrypt this value during Transform Map execution in the Global scope?

2. We cannot move the Transform Map to the scoped application because it is part of a sequence of Transform Maps that must remain in the Global application.

Could you please advise on the recommended approach for handling this scenario?

Thanks,

[Ankur Bawiskar]

@naveenreddy0871 

I was able to achieve this in past using ths

var backendAccount = new global.ScopedEncrypter().decrypt(supplierPaymentRecord.account_number);

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏