topic Re: Collections sorting in Alfresco Archive

Collections sorting

arikc — Wed, 15 Jun 2011 18:58:04 GMT

I am using the dynamic collection feature to retrieve the latest notices to be shown on the right pane of the web quick start root landing page:This is my query:select d.* from cmis:document as d where in_tree(d, '${section:/news/notices}') and d.cmisbjectTypeId='D:ws:article' and d.cmis:name not

Re: Collections sorting

arikc — Thu, 16 Jun 2011 03:57:51 GMT

I even tries using the static collection feature and sort it manually but to no avail. Regardless of what sequence I add the assets to the collection it seems that the earliest one appears at the top and the newest one appears at the bottom which is exactly opposite to what I want.

Re: Collections sorting

bremmington — Thu, 16 Jun 2011 09:26:08 GMT

Apologies again, but you have hit a known weakness that was addressed for dynamic asset collections (not static asset collections) a while ago - the enhancement made its way onto HEAD on 11th April 2011. Unfortunately there has been no community release since then, and in this case the change was too complex for me to recommend a manual patch, so you will have to either take a nightly build or wait for the next community release. Sorry.

Re: Collections sorting

tmath1 — Thu, 08 Sep 2011 02:02:16 GMT

is this change in 3.4.4 enterprise?

Re: Collections sorting

bremmington — Thu, 08 Sep 2011 07:56:50 GMT

Yes.