How Decrypt a value in GI from Payroll Settings screen?

Hi,

The issue is that the value in the database is encrypted. As a result, if the data field is used as part of an expression, it will pull the encrypted value.

As a workaround, add the data field to the results grid without using it as part of an expression/formula.

Hope this helps!

@MinushaWeerasuriya76  Thanks a lot for the prompt response.

Can you please help me with an example?

@MinushaWeerasuriya76 - This makes sense in the context of a GI, but his screenshot is from Employee Payroll Settings. It should not be scrambled there.

@darylbowman  Thanks for the response. But I don’t understand how this works for the OLD data records to display the value in the GI?

I’m not sure what you mean by old data records. Minusha’s comment was that it is an encrypted database field, and apparently there are some limitations with getting the decrypted value from the database when using it in a GI formula. This makes enough sense to me. However, your screenshot is from the out-of-the-box screen where the field should have no issues showing the decrypted value. This is what I was saying.

Hi @nsmith51 were you able to find a solution? Thank you!