• State Not Answered
  • Replies 2 replies
  • Subscribers 4 subscribers
  • Views 1415 views
  • Users 0 members are here
Related Discussions
Home » Discussions » Reports

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

kalpanap

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
  • 0
    A Score Level 2
    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.
Reply
  • 0
    A Score Level 2
    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.
Children
No Data
© 2024 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.