TeamDesk Knowledge Base & Support

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 (MMB) 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!

Scott Miller 8/25/2021 10:54:26 AM

Fell over this one again today. Would be a nice addition!

Luison Lassala 9/8/2021 12:05:24 PM

It would be very useful for sorting (detail) records like CHILDREN of a FAMILY (main record) in order of (calculated column) AGE.

Pierre 7/5/2023 10:06:51 AM

same need here