AnsweredAssumed Answered

Collections sorting

Question asked by arikc on Jun 15, 2011
Latest reply on Sep 8, 2011 by bremmington
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.

Outcomes