How to sort decrypted data for display in a table

[kryo91]

Hello, I have encrypted data in my database, in order to display them I decrypt them using variables, my client wants the data to be sorted but I cannot do it from the variables. how can I do

Thanks

[franse]

What about using an array after decrypt?

Working with Server Connect Array Lists

Intro The Server Connect Array List component allows you create and manipulate Array Lists easily with Server Connect actions. You can add items to an array, join multiple sources, remove and set arbitrary items, keep simple or complex objects or collections in an Array List. It’s also easy to use it as a string builder, when you need multi lines strings. Basics In order to be able to add items to an array you first need to define the array. The Array List actions are located in the Data Man…

And then

Dynamic Sortable Table

With Wappler you can create responsive, sortable data tables. First, you need to create a server action which contains a database query which will be used as a data source. In App connect panel add new component: [image] Open the data menu: [image] And add server connect component: [image] Then select your server action, which contains the database query: [image] Select the server action and click the select button: [image] We will show you how to store the sort order and directi…

[kryo91]

How to display my list in a table on my web page

[franse]

Hey, as I see in your screenshot, the repeat will create the array component for each record.
Try placing the create, the sort and the view outside the repeat.