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
ID
479
Category
TeamDesk
Author

Philipp Matuschka
Date Created
1/10/2012 11:12:32 AM
Date Updated
2/17/2018 4:21:49 PM
Status
New Idea
Score
90
Promoted By
Anton Avguchenkocooper collier Grant Simmons
Scott MillerDale OliverRafael Muñiz
Rick CogleyMartin OdendaalPhilipp Matuschka
Comments
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.

Thanks
Rafael
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.


cooper collier  2/14/2018 8:11:10 AM
Please recheck on this as its very important.
basenine 2/14/2018 6:53:50 PM
Grouping by filter would be nice too
Anton Avguchenko 2/17/2018 4:07:55 PM
Slava, Kirill - can you suggest a method or a work-around to implement a sorted concatenated summary? Thanks,
Anton
cooper collier  2/17/2018 4:20:24 PM
I have a very time-consuming solution I just performed for a client.
There is a very big limitation that you can only get as many records and you want to program in.
In this case, I did 5 total

Step one create index summaries, sort by created or modified date. whichever is appropriate.
Pick index 1,2,3 etc.

see this screen shot
https://goo.gl/UcyR7e

Now you combine the index in the order you want them in a new formula column
In my case, I used a xhtml column.

https://goo.gl/Cgbb2X

The last part, if the number of records is greater than 5, I display a warning that the rest of the records are in the sub view.

I hate to say this, but it's really the only solution for now.

Cooper
waterswebworks






Anton Avguchenko 2/17/2018 4:21:49 PM
Thank you Cooper!
Feedback
 
Back to Search Results