Hello again,
Please, I need to show project list join projectteam. Obviously the project name is repeating, so, I would like to set the field that I want in my agregate. Is there a way for this?
My alternative test was group by name, but I got two problems: performance got down and my agregate now only show the column of group by on my agregate (seting fields the id not exists but opening my agregate there is some fields there).
Where I'm going wrong on this issue?
Thanks
Hello
To get the unique data plus all other attributes we can use Advance SQL Row_Number() function with partition by, by the use of this we will get the row number of each record what we can do we will check in a where condition that rownumber =1 that means only records that are unique.
To know more on it just check on google about row_Number function to fetch unique records.
Thank you Tousif
Hi @Elaine Guimaraes,
When to use group by to get distinct values, It will return only attribute that are grouped. Please refer this document - https://success.outsystems.com/documentation/11/developing_an_application/use_data/query_data/get_distinct_values_from_the_database/
Thanks Sathish,
I am doing another list excluding the rwpeated project description. I saw this way in another post here in community.
Thanks!