Collections sorting

[arikc]

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.cmis:objectTypeId='D:ws:article' and d.cmis:name not like 'comment-thankyou.html' order by d.cmis:creationDate desc‍

The trouble is that I get the notices in ascending creation date even though I explicitly defined 'desc' as my sorting order. Not sure what I am doing wrong.

Thanks in advance.

[arikc]

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.

[bremmington]

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.

[tmath1]

is this change in 3.4.4 enterprise?

[bremmington]

Yes.