topic fileFolderService list sort natural numbers in name in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/filefolderservice-list-sort-natural-numbers-in-name/m-p/302637#M255767 <HTML><HEAD></HEAD><BODY><SPAN>Hi </SPAN><BR /><BR /><SPAN>My users are used to create folders with numbers in name in order to get a natural sort.</SPAN><BR /><SPAN>For ex :</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />|- 1 FOLDER1<BR />|- 2 FOLDER2<BR />|- 3 FOLDER3<BR />|- 4 FOLDER4<BR />|- 5 FOLDER5<BR />|- 6 FOLDER6<BR />|- 7 FOLDER7<BR />|- 8 FOLDER8<BR />|- 9 FOLDER9<BR />|- 10 FOLDER10<BR />|- 11 FOLDER11<BR />|- 12 FOLDER12<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></CODE></PRE><BR /><SPAN>They expects folders are displayed in this order but using fileFolderService.list like this </SPAN><BR /><BR /><PRE class="language-java line-numbers"><CODE><BR />List&lt;Pair&lt;QName, Boolean&gt;&gt; sortProps = new ArrayList() {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;{<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;add(new Pair&lt;&gt;(<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;GetChildrenCannedQuery.SORT_QNAME_NODE_IS_FOLDER, false));<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;add(new Pair&lt;&gt;(ContentModel.PROP_NAME, true));<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;};<BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;PagingResults&lt;FileInfo&gt; results = fileFolderService.list(parent,<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;!onlyFolders, true, null, sortProps, new PagingRequest(<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;skipCount, maxItems));<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></CODE></PRE><BR /><BR /><SPAN>they get this result :</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />|- 1 FOLDER1<BR />|- 10 FOLDER10<BR />|- 11 FOLDER11<BR />|- 12 FOLDER12<BR />|- 2 FOLDER2<BR />|- 3 FOLDER3<BR />|- 4 FOLDER4<BR />|- 5 FOLDER5<BR />|- 6 FOLDER6<BR />|- 7 FOLDER7<BR />|- 8 FOLDER8<BR />|- 9 FOLDER9<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></CODE></PRE><BR /><BR /><SPAN>Is it possible to give fileFolderService.list any option to sort correctly numbers ?</SPAN><BR /><BR /><SPAN>Thanks</SPAN><BR /></BODY></HTML> Wed, 18 Mar 2015 14:07:08 GMT leroux 2015-03-18T14:07:08Z fileFolderService list sort natural numbers in name https://connect.hyland.com/t5/alfresco-archive/filefolderservice-list-sort-natural-numbers-in-name/m-p/302637#M255767 Hi My users are used to create folders with numbers in name in order to get a natural sort.For ex <IMG id="smileyindifferent" class="emoticon emoticon-smileyindifferent" src="https://migration33.stage.lithium.com/i/smilies/16x16_smiley-indifferent.png" alt="Smiley Indifferent" title="Smiley Indifferent" />- 1 FOLDER1|- 2 FOLDER2|- 3 FOLDER3|- 4 FOLDER4|- 5 FOLDER5|- 6 FOLDER6|- 7 FOLDER7|- 8 FOLDER8|- 9 FOLDER9|- 10 FOLDER10|- 11 FOLDER11|- 12 FOLDER12‍‍‍‍‍‍‍‍‍‍‍‍‍‍They expects folders are displayed in Wed, 18 Mar 2015 14:07:08 GMT https://connect.hyland.com/t5/alfresco-archive/filefolderservice-list-sort-natural-numbers-in-name/m-p/302637#M255767 leroux 2015-03-18T14:07:08Z Re: fileFolderService list sort natural numbers in name https://connect.hyland.com/t5/alfresco-archive/filefolderservice-list-sort-natural-numbers-in-name/m-p/302638#M255768 <HTML><HEAD></HEAD><BODY><SPAN>Hello,</SPAN><BR /><BR /><SPAN>not to my knowledge. As long as users don't use 01, 02 … 10 for the leading numbers, this won't ever work. This is actually how our customers with similar "requirement" do it (like they also did in previous systems).</SPAN><BR /><BR /><SPAN>Regards</SPAN><BR /><SPAN>Axel</SPAN></BODY></HTML> Fri, 20 Mar 2015 09:26:01 GMT https://connect.hyland.com/t5/alfresco-archive/filefolderservice-list-sort-natural-numbers-in-name/m-p/302638#M255768 afaust 2015-03-20T09:26:01Z Re: fileFolderService list sort natural numbers in name https://connect.hyland.com/t5/alfresco-archive/filefolderservice-list-sort-natural-numbers-in-name/m-p/302639#M255769 <HTML><HEAD></HEAD><BODY><SPAN>Hello,</SPAN><BR /><BR /><SPAN>One of my colleague has implemented a solution modifying GetChildrenCannedQuery class. It's much a workaround than a robust implementation but we don't have enought time to spend on it.</SPAN><BR /><BR /><SPAN>Implementation here :</SPAN><BR /><A href="https://github.com/Itldev/Koya/commit/379d2433037bb17dc7afeb71bb93d5026e5d2936#diff-ed5818d69e1abc48b089d740ce08a113" rel="nofollow noopener noreferrer">https://github.com/Itldev/Koya/commit/379d2433037bb17dc7afeb71bb93d5026e5d2936#diff-ed5818d69e1abc48b089d740ce08a113</A><BR /><BR /><SPAN>Regards </SPAN><BR /><SPAN>chris</SPAN></BODY></HTML> Thu, 02 Apr 2015 07:18:39 GMT https://connect.hyland.com/t5/alfresco-archive/filefolderservice-list-sort-natural-numbers-in-name/m-p/302639#M255769 leroux 2015-04-02T07:18:39Z