Hi Mahmoud Yasaein,

There are many threads about this subject, try to see this link answer to see the next steps you should take :)

https://www.outsystems.com/forums/discussion/60728/display-group-by-data-in-reactive-web-app/

Hope it help you,

Thanks

Hi,

If you don't want use the group by in SQL, you can create an auxiliar table to store the returned data from SQL and that use an aggregate and manage the data with the group by function from aggregate.

Hi Mahmoud,

There's no straightforward way to do that in OutSystems, you need to program it yourself. That means iterating over the list with a For Each, keeping track of whether the grouped item(s) are still the same, and if so do a sum/min/max whatever over the other attributes you need in the output (and if not add it to the list, etc.).