1
 Follower
75
 Likes

Aggregate with distinct

Aggregates & Queries
On our radar
Aggregate should have an option to remove duplicates.

I see this as a new tab like "Sorting" where you could select the column you want to remove duplicates.
Created on 5 Oct 2015
Comments (29)
5 Oct 2015
Well, Simple Queries are the way of the past. From version 9, they are no longer available.
5 Oct 2015
Well, I think I'm the only one that miss the Simple Queries... but we should let it go anyway...
5 Oct 2015
Edit: I was talking about aggregate and not simple query.
Although we can work around this issue (by grouping all the fields) I still think there could be this way to simplify queries
6 Oct 2015
@Andre: I miss them too!

@Ricardo, agreed, like a DISTINCT
6 Oct 2015
Edit: I was talking about aggregate and not simple query.
Although we can work around this issue (by grouping all the fields) I still think there could be this way to simplify queries
This idea is great.
I'm hoping to see this implemented as soon as possible.
6 Oct 2015
Agree! the distinct option would improve the aggregates alot.
6 Oct 2015
How could this not to be implemented yet?
@Ricardo, good idea!
6 Oct 2015
This was suggested 5 years ago for Simple Queries, marked as "Done" but never implemented as far as I know:

http://www.outsystems.com/ideas/260/distinct-select-possible-on-a-simple-query

Then again (with the same result) four years ago:

http://www.outsystems.com/ideas/846/distinct-parameter-in-simple-queries

This really is needed.

J.Ja
6 Oct 2015
yes!


7 Mar 2016
up
Please foresee this for aggregates
16 Aug 2016

up

14 Dec 2016

DO IT!!

21 Apr 2017

up

But why are we creating duplicates?

17 May 2017

Because my join creates them?

22 May 2017

Up! Please don't make me do another list to sort distinct again.

Yes, distinct would be helpful

27 Oct 2017

Hey ,  alternate way to distinct  a Aggregate get to append all  to list record and distinct that list record using  DISTINCTRECORDLIST  in  SORTRECORDLIST component. 

27 Oct 2017

@Rocky yes, but that takes extra time, especially for long lists, and also forces the entire query output to be retrieved, which can degrade performance.

As for a workaround, you can Group on all the output columns you need, which will implicitely make them distinct. Also not a very nice solution, but better than post-processing.

7 Nov 2017

PLEASE DO IT!!!

8 Nov 2017

just do it!

Hopefully, the aggregate accomodates all the Advanced Query's capabilities as easy as possible.

regards,

bb

8 Nov 2017

Certainly!


1 Dec 2017

Please do it.

Up \o/

Isn't this how the "Group by" function already works in aggregates?

views
1265
Followers
1