How to sort aggregate, dynamic or static?

basically i tried to save the dropdown input in local variable,(this part is okay). but how to sort the list using this local variable. i dont really understand how to use dynamic sort. the value for each record is integer 1,2,3,4,5. i swear if it something so simple. ┻━┻ ︵╰(°□°╰) 


Hi Irfan,

Have you checked the learning course here? It shows the steps for you to use the dynamic sort manually.

Alternatively, you have the option to create the sorting automatically. 

This will work if you use simple aggregate (without GroupBy).

But if you use Group By, you have to rename your HeaderCell to use your GroupBy's NameExample above will be RecordName for the SortAttribute, in the logic itself, you have to refactor "RecordName" to "Record.RecordName" for the aggregate to work. 


If SortBy = "RecordName"

Then SortBy = "Record.RecordName"

For static sorting, you just have to add the attribute under Sorting in the aggregate.

If you want to use dropdown list to sort your listing, you have to define that as well, 

DropdownOnChange -> If(SelectedId = Entities.SortBy.Favourite), SortBy = "Table.IsFavourite", ...)

The training really helps you with the basics. Hope it helps.


my god i knew its something so easy. i just change the static entity value into text and change it to somthing like "Product.Price DESC" instead. i didnt know there were that kind of training. thank you so much🙏 

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.