topic Pagination: Best practice ?? in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/pagination-best-practice/m-p/238854#M191984 <HTML><HEAD></HEAD><BODY><SPAN>Hi everybody,</SPAN><BR /><BR /><SPAN>For my Web application based on Alfresco 3.1 (Repository services), I need to display the content of a space (the list of file).</SPAN><BR /><SPAN>Lot of space have a lot of file (500, 1000, maybe more in the futur…).</SPAN><BR /><BR /><SPAN>So, in my own service, I need to manage a pagination in order to get files by bloc (10 by 10 in my case).</SPAN><BR /><BR /><SPAN>But by using for example </SPAN><PRE class="language-none line-numbers"><CODE>fileFolderService.listFiles(spaceNodeRef)<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN></CODE></PRE><SPAN>, this service return ALL files… So it is not possible to use this service's method…&nbsp; <img id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://connect.hyland.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" />ops: </SPAN><BR /><BR /><SPAN>A solution that I found, is to use the searchService in order to call Lucene </SPAN><PRE class="language-none line-numbers"><CODE>searchService.query(params);<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN></CODE></PRE><SPAN>, by setting a limit of record to return </SPAN><PRE class="language-none line-numbers"><CODE>params.setLimit(limit); params.setLimitBy(LimitBy.FINAL_SIZE);<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN></CODE></PRE><SPAN>. So for the first page, I will fixe the limit to 10 (if I want 10 files per page). for the second page, I will fixe the limit to 20 (and I will filter the result list to take the last 10 files…), and so&nbsp; one… So If&nbsp; I want&nbsp; to see the page #15, I will oblige to set the limit to 150 !! So you can imagine that for first pages my solution is simple, but for all last pages it is the same solution than using </SPAN><PRE class="language-none line-numbers"><CODE>fileFolderService.listFiles(spaceNodeRef)<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN></CODE></PRE><SPAN>…</SPAN><BR /><BR /><SPAN>Moreover, and because I need to now the count of files inside the Space (I need to have the count total to calculate the number of page), I use a freemarker&nbsp; template treatment:</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />// Create the model object<BR />HashMap model = new HashMap(1, 1.0f); <BR />TemplateNode templateNode = new TemplateNode(spaceNodeRef, this.serviceRegistry, null);<BR /> model.put("thespace", templateNode);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR />// Template freemarker<BR />String xChilds = super.getTemplateService().processTemplateString("freemarker", "&lt;#list thespace.children as child&gt;&lt;#if child.isDocument&gt;x&lt;/#if&gt;&lt;/#list&gt;", model);<BR />int totalGeneral = xChilds.length();<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></CODE></PRE><SPAN>Ok I agree that it is not the best solution… but how to know the number of file in a space !???</SPAN><BR /><BR /><SPAN>So, all this explaination, just to show my solution, and to know WHAT IS BEST PRACTICE FOR MANAGE PAGINATION !!</SPAN><BR /><SPAN>I cannot understand that with all these big project developped over Alfresco, no-one find a GOOD solution.</SPAN><BR /><BR /><SPAN>I read that in the 3.2 version, a pagination system was propose !!!</SPAN><BR /><SPAN>Maybe in the searchService, because I saw in the 3.2 searchService API this new method:</SPAN><BR /><PRE class="language-none line-numbers"><CODE>setSkipCount(int skipCount) with the exaplaintation =&gt; Set the skip count - the number of rows to skip at the start of the query.<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>Is it the case !?</SPAN><BR /><BR /><SPAN>Thansk to everybody,</SPAN><BR /><SPAN>and sorry for my poor english, I am French&nbsp; :mrgreen: … and As all froggies I don't speak very well english <img id="smileyvery-happy" class="emoticon emoticon-smileyvery-happy" src="https://connect.hyland.com/i/smilies/16x16_smiley-very-happy.png" alt="Smiley Very Happy" title="Smiley Very Happy" />&nbsp; <img id="smileyvery-happy" class="emoticon emoticon-smileyvery-happy" src="https://connect.hyland.com/i/smilies/16x16_smiley-very-happy.png" alt="Smiley Very Happy" title="Smiley Very Happy" /></SPAN></BODY></HTML> Thu, 08 Apr 2010 17:36:54 GMT alex54 2010-04-08T17:36:54Z Pagination: Best practice ?? https://connect.hyland.com/t5/alfresco-archive/pagination-best-practice/m-p/238854#M191984 Hi everybody,For my Web application based on Alfresco 3.1 (Repository services), I need to display the content of a space (the list of file).Lot of space have a lot of file (500, 1000, maybe more in the futur…).So, in my own service, I need to manage a pagination in order to get files by bloc (10 by Thu, 08 Apr 2010 17:36:54 GMT https://connect.hyland.com/t5/alfresco-archive/pagination-best-practice/m-p/238854#M191984 alex54 2010-04-08T17:36:54Z Re: Pagination: Best practice ?? https://connect.hyland.com/t5/alfresco-archive/pagination-best-practice/m-p/238855#M191985 <HTML><HEAD></HEAD><BODY><SPAN>no one did this in the past ???</SPAN><BR /><SPAN>thanks</SPAN></BODY></HTML> Tue, 13 Apr 2010 12:27:06 GMT https://connect.hyland.com/t5/alfresco-archive/pagination-best-practice/m-p/238855#M191985 alex54 2010-04-13T12:27:06Z