Home      FAQ      Forum      Idea Exchange      Ask a Question      My Stuff      Help   
Sort when concatenating
When doing a concatenate the default is, understandably, that the concatenate is in order of ID. It would be very useful to be able to define in which order the concatenation is done. For example one might one to concatenate a series of events, but sort them on the evnt date, which may not be in the same order as the ID

Philipp Matuschka
Date Created
1/10/2012 11:12:32 AM
Date Updated
3/18/2016 9:43:32 AM
New Idea
Promoted By
Grant SimmonsScott MillerDale Oliver
Rafael MuñizRick CogleyMartin Odendaal
Philipp Matuschka
Kirill Bondar  Staff  1/10/2012 1:16:49 PM
Here we are tied to underlying database (namely MS SQL Server R2) features. So far they do not support ordering for custom aggregate functions such as Concatenate. Once they do this will open us the way to implement a lot of statistical calculations as well.
Philipp Matuschka 1/11/2012 4:06:08 AM
Have they announced any plans to do so?
Kirill Bondar  Staff  1/11/2012 6:41:58 AM
The functionality is split between two products: the function is coded using .NET and they have documented an attribute to specify whether aggregate function is invariant to order of the data or not, but documentation states it is "reserved for future use". Yet, the attribute by itself does nothing - it is merely a flag for SQL to know whether the data it feeds to a function needs an ordering or not - but SQL documentation says nothing about the attribute.

Upcoming SQL 2012 release notes mention some improvements they've made for aggregate functions but its not clear whether they are applicable for custom aggregates. Yet the product is in early stage and documentation is obviously is not complete.
Rafael Muñiz 10/22/2015 11:11:55 AM
When you use "Concatenate" in a Summary, you may need to obtain the result sorted alphabetically...

It will be great if you can add this "sort" option.

Slava Shinderov  Staff  10/22/2015 11:19:07 AM
Merged with:
915 - Concatenate Summary, with the ability to sort.
Scott Miller 3/18/2016 9:43:32 AM
@Kirill Is there any update on this as I now find myself in need of this functionality.

Back to Search Results