1
0
-1

I have an encrypted field in a table in an app, hence the value is not clear text in the database, thats ok.


how each day i need to run a report or extract to csv and show records matching a specific time/date range, the thing is i also need to show the decrypted/clear text value in the report.


how do i get the decrypted value in say in excel or csv extract., in short how do i even select the clear text value from the database.

    CommentAdd your comment...

    2 answers

    1.  
      1
      0
      -1

      How do you "run a report or extract to csv"?

      Since value encryption happens at Joget app layer, therefore we need to decrypt it at Joget layer too. What Anders suggested sounds good.

        CommentAdd your comment...
      1.  
        1
        0
        -1

        Hi, you could try to use the Hash Variable#FormDataHashVariable to display the field value in your report.

          CommentAdd your comment...