topic ORDER BY Name in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/order-by-name/m-p/201004#M154134 <HTML><HEAD></HEAD><BODY><SPAN>Hello,</SPAN><BR /><BR /><SPAN>I am trying to retrieve sorted documents by name with CMIS query. My query looks very simple:</SPAN><BR /><BR /><SPAN>select * from document where IN_FOLDER('workspace://SpacesStore/cdeb288c-da2b-4cc9-8881-68fc311e67db') ORDER BY Name</SPAN><BR /><BR /><SPAN>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)</SPAN><BR /><BR /><SPAN>Currently I am working with Alfresco version 3.0.0 (Stable 1526), using air CMIS Explorer to execute this query.</SPAN><BR /><BR /><SPAN>What can be reason of incorrect alphabetical order of documents:</SPAN><BR /><SPAN> - Am I doing something wrong?</SPAN><BR /><SPAN> - Is it some bug in alfresco version I am working with? </SPAN><BR /><SPAN> - Probably, is it solved in some future versions?</SPAN><BR /><BR /><SPAN>Thank You in advance!</SPAN></BODY></HTML> Fri, 24 Apr 2009 15:21:27 GMT ashved 2009-04-24T15:21:27Z ORDER BY Name https://connect.hyland.com/t5/alfresco-archive/order-by-name/m-p/201004#M154134 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 NameAs result of this query I have documents in some random order, not alphabetically sor Fri, 24 Apr 2009 15:21:27 GMT https://connect.hyland.com/t5/alfresco-archive/order-by-name/m-p/201004#M154134 ashved 2009-04-24T15:21:27Z Re: ORDER BY Name https://connect.hyland.com/t5/alfresco-archive/order-by-name/m-p/201005#M154135 <HTML><HEAD></HEAD><BODY><SPAN>Your syntax looks right, but in my own testing I have found that the ORDER BY clause tends to not work correctly. It does change the order of the results, but not in any consistent way that I can figure out. Looks like if you want them in a specific order you are going to need to do it yourself.</SPAN><BR /><BR /><SPAN>I have tried this on 3.0, but because my preview build 3.2 is messed up at the moment I haven't checked that.</SPAN></BODY></HTML> Mon, 27 Apr 2009 18:08:46 GMT https://connect.hyland.com/t5/alfresco-archive/order-by-name/m-p/201005#M154135 jake-hyland 2009-04-27T18:08:46Z