AnsweredAssumed Answered

ORDER BY Name

Question asked by ashved on Apr 24, 2009
Latest reply on Apr 27, 2009 by jake-hyland
Hello,

I am trying to retrieve sorted documents by name with CMIS query. My query looks very simple:

select * from document where IN_FOLDER('workspace://SpacesStore/cdeb288c-da2b-4cc9-8881-68fc311e67db') ORDER BY Name

As result of this query I have documents in some random order, not alphabetically sorted by name. (I have also tried to order by some other properties: modification Date, document size; with such order results are sorted correctly)

Currently I am working with Alfresco version 3.0.0 (Stable 1526), using air CMIS Explorer to execute this query.

What can be reason of incorrect alphabetical order of documents:
- Am I doing something wrong?
- Is it some bug in alfresco version I am working with?
- Probably, is it solved in some future versions?

Thank You in advance!

Outcomes