I've got a dataset with a basic list of clients. In the Database the data is sorted according to "CustomerName" as shown below.
When using the data to create a table it initially sort the information by the ID as show below.
How do I set the initial sorting of the table to be according to the Customer name instead of ID?
(Apologies for such a basic question, just started the learning process!)
Hi, usually, when you creating table by drag & drop Aggragate to canvas, OutSystems will automatically generate Sorting logic for you, there'll be TableSort variable to hold the default sorting. In this case just set it like this:
If this is not the case, please let us know so we will have another guidance.
Hi,
To understand correctly, so your table is directly bind to the aggregate shown in screenshot? If that's the case, then it looks fine & should work as you have set the sorting in aggregate with customer name ASC., On page load ideally you should see the data sorted by customer name in ascending order. If that's okay, then can you share OML to take a better look and see what else could be the reason.