topic Lucene search sort troubles in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/lucene-search-sort-troubles/m-p/227957#M181087 <HTML><HEAD></HEAD><BODY><SPAN>I'm having troubles understanding how the sort works. </SPAN><BR /><SPAN>When I take a look at the script below, I expect to get a result-set ordered by title. However, this is not the case, and instead I get the result-set that can also be found below. </SPAN><BR /><BR /><SPAN>Any ideas why this happens?</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE>var logFile = userhome.childByNamePath("test.txt");<BR /><BR />if (logFile == null) {<BR />&nbsp;&nbsp;&nbsp;var logFile = userhome.createNode("test.txt", "cm:content");<BR />}<BR /><BR />var sortby = "@" + "cm:title";<BR />var query = "PATH:\"" + "/app:company_home/cm:test" + "//*\"";<BR />query += " AND " + "ASPECT:\"" + "cm:folder" + "\"";<BR /><BR />var results = search.luceneSearch(query, sortby, false); <BR />&nbsp;&nbsp;&nbsp;<BR />for each (result in results) {<BR />&nbsp;&nbsp;&nbsp;logFile.content += result.properties["cm:title"] + "\n";<BR />}<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><PRE class="language-none line-numbers"><CODE>vtest3 vtest3_1273647023066.tiff<BR />UP1_Ulazna <BR />UP1_Izlazna_1 <BR />UP1_6 <BR />UP1_5<BR />UP1_4 <BR />test9 <BR />test8 <BR />test7 <BR />test66<BR />test6 <BR />test55 <BR />test5 <BR />test4 <BR />test3 <BR />test22<BR />test2 <BR />test10 <BR />test <BR />test<BR />test<BR />racun<BR />NEUPasdasd <BR />asdhasdhdlhkasdhl <BR />asdadasd <BR />333333 <BR />222222 <BR />21e12e2sdss <BR />test<BR />tes1111111<BR />test123123<BR />test2<BR />test3<BR />test1<BR />test2<BR />test3<BR />test4<BR />test5<BR />test6<BR />test19<BR />test13<BR />test8<BR />1414<BR />1515<BR />1616<BR />1717<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE></BODY></HTML> Mon, 19 Jul 2010 12:45:53 GMT lista 2010-07-19T12:45:53Z Lucene search sort troubles https://connect.hyland.com/t5/alfresco-archive/lucene-search-sort-troubles/m-p/227957#M181087 I'm having troubles understanding how the sort works. When I take a look at the script below, I expect to get a result-set ordered by title. However, this is not the case, and instead I get the result-set that can also be found below. Any ideas why this happens?var logFile = userhome.childByNamePath Mon, 19 Jul 2010 12:45:53 GMT https://connect.hyland.com/t5/alfresco-archive/lucene-search-sort-troubles/m-p/227957#M181087 lista 2010-07-19T12:45:53Z Re: Lucene search sort troubles https://connect.hyland.com/t5/alfresco-archive/lucene-search-sort-troubles/m-p/227958#M181088 <HTML><HEAD></HEAD><BODY><SPAN>If I exclude the PATH part of the query, the sort appears to work fine. It looks to me that in case of using PATH as a part of your query, 'sort-by' sorts sub-folder by sub-folder, thus making the complete result-set look out of order. Can anyone reproduce this and possibly confirm the issue?</SPAN></BODY></HTML> Mon, 19 Jul 2010 13:03:54 GMT https://connect.hyland.com/t5/alfresco-archive/lucene-search-sort-troubles/m-p/227958#M181088 lista 2010-07-19T13:03:54Z