I don't know if it should be an option in the platform? There are a lot of ways possible in the 'sorting way'. So wouldn't it be better that this option be available trough an extension like <this>?

The system action has many advantages over the extension. The most important is, in my opinion, having the true change when you rename or remove a field that is being referenced by a sort. Also, you don't need to cast the record list to an object, which is a non-obvious step required by the extension.

Can understand that, but that also isn't the case with the RW table column sorting widget so would it be possible here?

Hello, This idea is marked as 'on our radar' but I found in OutSystems forums this Forum Post which is linking to this answer. Isn't this working properly? Just asking because is marked as a Solution. It can be misleading.

Franco,

That just links to a workaround (and one with a number of caveats). It would be nice if this was supported natively (hence this Idea).

Is there any updates on this?

SortRecordList Forge extension allows us to sort by a combination of attributes but, currently, when selecting the sort type this will be applied to all the attributes.

Just as an addon it would be great to select the sort type per attribute, ascending or descending, like we normally do in a query. 

E.g. "Date Desc, Time Desc, Name Asc"

I'd like to add something to this idea, using José Ventura's comment.

I propose extending on José's comment with a rebuilt visual ListSort that would help users sort by multiple attributes and assign "descending" or "ascending" to each one.

Here's a sketch that I drew in paint to show the behavior:

1st step: User fills in the "List" property with a Record List Variable. The platform will read the attributes of that RecordList and will allow the user to choose the sort criteria;

2nd step: The user chooses the 1st criteria of sorting by opening the attributes combobox, which the platform would of pre-filled with all available simple type attributes in the structure (you can't sort by binary data, record or record list type attributes, of course). After selecting the attribute, the "Ascending/Descending" combobox will be available, defaulting to "Ascending". At the same time, the platform will open up a "2nd criteria" row with the same attributes combobox, allowing the user to continue to sort if he so chooses, etc...;

3rd step: If the user has more than 1 criteria, the arrows on the left will appear to allow the user to change criteria order;

I think this would cover all use cases. And would have the benefit of the true engine / self heal in Service Studio being able to check errors in the sort criteria, if there's a change in the structure of the original RecordList.

Is there any update on this?

Hi Nguyen,

Unfortunately not. In the meantime, if you're on O11, you can use the SortRecordList Forge Asset.

In addition, if your use case allows it, you can use in the front end Outsystems Reavtive Data Grid, that have advanced functionality for such cases. There are some limitations tho, but in general is very usefull.

Thanks for your reply, i wrote extention instead. My action is batch,it only works in server side so i cant use JavaScript or Agg to sort by multi columns.