I have a UI in report with various fields kept as search filters.

I have a UI in report with various fields kept as search filters. I have used a!queryFilter to find the match from text entered by user to check in database.

One such field search in UI has values saved as encrypted text in database.

So when i make a search, with eg. "Box" in UI and same is saved as "hsk826e874213evsdbadch8edvdjvsnacvds" in backend. How to achieve the search as a!queryFilter() or anyother can be user to perform the search.

In above scenario - if i enter "hsk" result is returned. If i enter "Box" no results is found.

OriginalPostID-194396

  Discussion posts and replies are publicly visible

Parents
  • Hi Kalpana, I am not sure the mechanism you are using for the encryption. one way is to use keyencrypt() while persisting to databsae and then you can use the keydecrypt() create a rule and apply this rule in the values before passing the expression input.

    you can keep the key and transformation as constants so that they can be reused in both places while encryption and decryption, only cleartext and ciphertext will be variables.
Reply
  • Hi Kalpana, I am not sure the mechanism you are using for the encryption. one way is to use keyencrypt() while persisting to databsae and then you can use the keydecrypt() create a rule and apply this rule in the values before passing the expression input.

    you can keep the key and transformation as constants so that they can be reused in both places while encryption and decryption, only cleartext and ciphertext will be variables.
Children
No Data