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

kalpanap over 8 years ago

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.

Discussion posts and replies are publicly visible

0 narasimhaadityac
A Score Level 2
over 8 years ago

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.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 narasimhaadityac
A Score Level 2
over 8 years ago

Hi Kalpana, Please dis regard my previous comment. sorry for the confusion.

I understand that you are using a!encryptedTextField() in order to store the information in encrypted format.

We may be able to get this working only for "EQUALS" where we can use the same field pattern and try to use it in the query entity.. other operations will not work as the encrypted text will be differ for each of the values i mean for Box, Bo, B the values will be different.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel