topic FileFolderService.list(): sort by folder, then by file in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/filefolderservice-list-sort-by-folder-then-by-file/m-p/294765#M247895 <HTML><HEAD></HEAD><BODY><SPAN>Hello,</SPAN><BR /><BR /><SPAN>I am using the FileFolderService &lt;a href="</SPAN><A href="http://dev.alfresco.com/resource/docs/java/repository/org/alfresco/service/cmr/model/FileFolderService.html#list(org.alfresco.service.cmr.repository.NodeRef,%20boolean,%20boolean,%20java.util.Set,%20java.util.List,%20org.alfresco.query.PagingRequest)" rel="nofollow noopener noreferrer">http://dev.alfresco.com/resource/docs/java/repository/org/alfresco/service/cmr/model/FileFolderService.html#list(org.alfresco.service.cmr.repository.NodeRef,%20boolean,%20boolean,%20java.util.Set,%20java.util.List,%20org.alfresco.query.PagingRequest)</A><SPAN>"&gt;list&lt;/a&gt; method to list files and folders in a custom web script, but I cannot figure out how to sort by file/folder type.</SPAN><BR /><BR /><SPAN>I see that the list method takes a List&lt;Pair&lt;QName, Boolean&gt;&gt; as the sortProps parameters. So if I wanted to sort first by creator and then by name, I would create a List like so:</SPAN><BR /><BR /><PRE class="language-java line-numbers"><CODE><BR />import java.util.ArrayList;<BR />import java.util.List;<BR />import org.alfresco.model.ContentModel;<BR />import org.alfresco.service.namespace.QName;<BR />import org.alfresco.util.Pair;<BR />…<BR /><BR />List&lt;Pair&lt;QName, Boolean&gt;&gt; sortProps = new ArrayList&lt;Pair&lt;QName, Boolean&gt;&gt;();<BR />sortProps.add(new Pair&lt;QName, Boolean&gt;(ContentModel.PROP_CREATOR, true));<BR />sortProps.add(new Pair&lt;QName, Boolean&gt;(ContentModel.PROP_NAME, true));<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></CODE></PRE><BR /><BR /><SPAN>But I do not see any property that I could use to sort by type to group the folders together and the files together. It would be nice if I could create a sortProps to sort on FileFolderServiceType first, and then the name property like so:</SPAN><BR /><BR /><PRE class="language-java line-numbers"><CODE><BR />List&lt;Pair&lt;QName, Boolean&gt;&gt; sortProps = new ArrayList&lt;Pair&lt;QName, Boolean&gt;&gt;();<BR />sortProps.add(new Pair&lt;QName, Boolean&gt;(ContentModel.FILE_FOLDER_TYPE, true));<BR />sortProps.add(new Pair&lt;QName, Boolean&gt;(ContentModel.PROP_NAME, true));<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><BR /><SPAN>Of course there is no QName ContentModel.FILE_FOLDER_TYPE, but is there anything like this that I can use?</SPAN><BR /><BR /><SPAN>My desire is to create a view to use my web script which would (by default) sort by title - folders first followed by files. If the user wishes to sort by something else, the folders and files may be mixed in together. The view will be paged, using something like &lt;a href="</SPAN><A href="http://www.infinite-scroll.com/" rel="nofollow noopener noreferrer">http://www.infinite-scroll.com/</A><SPAN>"&gt;infinite-scroll&lt;/a&gt;</SPAN><BR /><BR /><SPAN>I see there was an issue created in Jira for Share which may be similar: </SPAN><A href="https://issues.alfresco.com/jira/browse/MNT-2275" rel="nofollow noopener noreferrer">https://issues.alfresco.com/jira/browse/MNT-2275</A><SPAN>. I am not using Share for this, but I was wondering if its fix can fix my problem.</SPAN><BR /><BR /><SPAN>I am developing for Alfresco v4.1.2.</SPAN></BODY></HTML> Fri, 24 Jan 2014 15:14:37 GMT hutago 2014-01-24T15:14:37Z FileFolderService.list(): sort by folder, then by file https://connect.hyland.com/t5/alfresco-archive/filefolderservice-list-sort-by-folder-then-by-file/m-p/294765#M247895 Hello,I am using the FileFolderService &lt;a href="http://dev.alfresco.com/resource/docs/java/repository/org/alfresco/service/cmr/model/FileFolderService.html#list(org.alfresco.service.cmr.repository.NodeRef,%20boolean,%20boolean,%20java.util.Set,%20java.util.List,%20org.alfresco.query.PagingRequest Fri, 24 Jan 2014 15:14:37 GMT https://connect.hyland.com/t5/alfresco-archive/filefolderservice-list-sort-by-folder-then-by-file/m-p/294765#M247895 hutago 2014-01-24T15:14:37Z Re: FileFolderService.list(): sort by folder, then by file https://connect.hyland.com/t5/alfresco-archive/filefolderservice-list-sort-by-folder-then-by-file/m-p/294766#M247896 <HTML><HEAD></HEAD><BODY><SPAN>You can try to use following properties which are defined in org.alfresco.repo.node.getchildren.GetChildrenCannedQuery</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />&nbsp;&nbsp;&nbsp; public static final QName SORT_QNAME_NODE_TYPE = QName.createQName("", "TYPE");<BR />&nbsp;&nbsp;&nbsp; public static final QName SORT_QNAME_NODE_IS_FOLDER = QName.createQName("", "IS_FOLDER"); <BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /></BODY></HTML> Fri, 24 Jan 2014 20:07:50 GMT https://connect.hyland.com/t5/alfresco-archive/filefolderservice-list-sort-by-folder-then-by-file/m-p/294766#M247896 kaynezhang 2014-01-24T20:07:50Z Re: FileFolderService.list(): sort by folder, then by file https://connect.hyland.com/t5/alfresco-archive/filefolderservice-list-sort-by-folder-then-by-file/m-p/294767#M247897 <HTML><HEAD></HEAD><BODY><SPAN>Thank you, kaynezhang. The </SPAN><PRE class="language-none line-numbers"><CODE>SORT_QNAME_NODE_TYPE<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN></CODE></PRE><SPAN> was exactly what I was looking for. It worked splendidly!</SPAN></BODY></HTML> Mon, 27 Jan 2014 17:57:56 GMT https://connect.hyland.com/t5/alfresco-archive/filefolderservice-list-sort-by-folder-then-by-file/m-p/294767#M247897 hutago 2014-01-27T17:57:56Z