How is your experience with the OutSystems Community?
414
Views
8
Comments
Dynamic sort stops working on aggregates grouping fields when a new column is grouped
Question

Hi,

 

There's a Service Studio issue that may be as old as the aggregates are and hasn't been fixed yet:

 

Let's say there's a webscreen listing data in a table records which has as source an aggregate that is grouping fields and is sorting them using a dynamic sort which is receiving as input the group-by-field-aliases defined in the sort widgets present in the tablerecords header cells and it all works as expected.

 

Now there's a new column to add to the tablerecords so we need to:

1 - add the field to add to the aggregate group by

2 - add the column to the table records and configure the sort by widget with the new group-by-field-alias

 

This should be enough to have the screen properly order the table records by that new column but unfortunately service studio has a bug and this does not work. We still need to 

3 - open the aggregate "sorting" tab, copy the text present in the dynamic sort, delete the dynamic sort, create a new dynamic sort and past the exact same content the previous dynamic sort had 

 

Only then the sorting starts to work.

 

I'm sure that, like me, many other developers stumbled upon this issue, did the third step, got the aggregate to work and moved on but having developers forget about the extra non intuitive and supposed to be unnecessary third step it is really something that is bound to keep on happening so i just wanted to have this posted here so that maybe the probability of R&D keeping on forgetting about this bug lowers a bit.

2018-10-29 08-31-03
João Marques
Ā 
MVP

Hi Filipe,


Indeed it is something it already made me struggle to understand the issue.

It would be great if the platform could made this visible.


Thanks for sharing.

João

2023-02-07 12-18-42
Pedro Gameiro

Hi, i had the same problem, every time a new group is added, the sort needs to be deleted and added again.

2021-10-25 16-20-08
Miguel Ramos

Thank you @Pedro Gameiro. It works!

2025-10-21 04-03-24
DaVince

Until now, this issue still persists.

I wasted hours trying to figure this out. Thank God I finally stumbled upon this post. Thank you.

UserImage.jpg
João Franco Santos

Hi all,

This is still and issue. 

Thank you OP


Cheers.

UserImage.jpg
Pedro Duque

It's not intuitive at all but it works.

Just to make it clean: you need to remove the dynamic sort and put it again each time you change the grouping!

2017-12-15 03-31-24
Lennie Sutton

Hi, Filipe,

    I just ran into this myself and sure enough removing and recreating the Dynamic Sort resolved the issue.  Thank you!

Lennie

2025-12-19 11-44-03
Marvei Paña

Thank you for this,

Spent an hour figuring it out, this should be fixed by Outsystems, its almost 7 years since it was reported

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