Sorting and Searching Data Encrypted with password

[Journeyman]

Wappler 7.00 b26
NodeJs

Hi All
I am developing a system using some data fields which are encrypted with password. I can decrypt ok, and currently using it in a repeat table. I am trying to make the columns sortable via headers. However when it sorts, it's sorting on the encrypted data. How do I force the sort on the decrypted data

Thanks

[franse]

Hello!

@Journeyman

it's sorting on the encrypted data

What do you see on the output, the encrypted data?
Check if you can use serverside arrays:

How to modify database query result in server actions?

Hello! What about using server connect arrays? Create a query with no output: [image] Then you create an array with the nedeed schema: [image] A repeat action that will add each record to the array with the encripted value: [image] And finally, a Get array list [image] Result: [image] If you’re using encrypt options don’t forget to backup everything before testing

PS: In the example above I used encrypt, but you can use decrypt

[Journeyman]

Thanks, that looks like it will work. I'll have a play and let you know

[Apple]

Are you decrypting server-side or client-side? If you're doing decrypting client-side I guess you can use a Data Store component to store the data decrypted

P.S.: I think the Data Store component saves the data in the browser's local storage, so depending on your security requirements it might not be appropriate. Alternatively, I think you could use a dmx-repeat and edit the fields directly (e.g. through a Page Flow) instead of using an intermediary Data Store component

[Journeyman]

Thanks, I'm using the encrypt/decrypt with password so it's serverside. As the data is only displayed in table form and users will not edit it, I'm consideinring using a data store on the client side for the decrypted data and blitz it when the user logs out . From a security perspective it feels ok but need to investigate further