topic Opencmis extension paging problem in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/opencmis-extension-paging-problem/m-p/276008#M229138 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><SPAN>i'm having problems using pagination with opencmis extension : if the last page contains only one results the "currentPage.getHasMoreItems()" on second-last page returns false and i lose one result.</SPAN><BR /><SPAN>For example if i set MaxItemPerPage to 10 and there are 21 results, the last is not retrieved.</SPAN><BR /><BR /><SPAN>I have installed Alfresco community 4.0.d (alfresco-community-4.0.d-installer-win-x64.exe)</SPAN><BR /><BR /><SPAN>Creation of session in client:</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SessionFactory factory = SessionFactoryImpl.newInstance();<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Map&lt;String, String&gt; parameter = new HashMap&lt;String, String&gt;();<BR />&nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;// user credentials<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;parameter.put(SessionParameter.USER, configurationUtils.getCmisUserLogin());<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;parameter.put(SessionParameter.PASSWORD, configurationUtils.getCmisUserPassword());<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // ATOMPUB binding<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;parameter.put(SessionParameter.ATOMPUB_URL, configurationUtils.getCmisBindingUrl()); <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;parameter.put(SessionParameter.BINDING_TYPE, BindingType.ATOMPUB.value());<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;parameter.put(SessionParameter.OBJECT_FACTORY_CLASS, "org.alfresco.cmis.client.impl.AlfrescoObjectFactoryImpl");<BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; List&lt;Repository&gt; repositories = factory.getRepositories(parameter);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; this.session = repositories.get(0).createSession();<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<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></CODE></PRE><BR /><SPAN>Query with pagination to cmis:</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Session session = cmisClient.getSession();<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;OperationContext operationContext = new OperationContextImpl();<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;operationContext.setMaxItemsPerPage(10);<BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;String queryString = "select d.*,w.* "<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;+ "from cmis:document as d join adp:my_aspect as w on d.cmis:objectId = w.cmis:objectId "<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;+ "where w.adp:stato = 'DA INVIARE'";<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ItemIterable&lt;QueryResult&gt; results = session.query(queryString, false,operationContext);<BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;int pageNumber = 0;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;boolean finished = false;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;int count = 0;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;while (!finished) {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ItemIterable&lt;QueryResult&gt; currentPage = results.skipTo(count).getPage();<BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;for (QueryResult qResult : currentPage) {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;String objectId = "";<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;PropertyData&lt;?&gt; propData = qResult.getPropertyById("cmis:objectId"); // Atom Pub binding<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if (propData != null) {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;objectId = (String) propData.getFirstValue();<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;} else {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//TODO: decidere se fare o meno<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;objectId = qResult.getPropertyValueByQueryName("d.cmis:objectId"); // Web Services binding<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;CmisObject obj = session.getObject(session.createObjectId(objectId));<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;count++;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;_log.info("CMIS obj id: [" + obj.getId() + "], name:["+ obj.getName() + "], adp:status: ["+obj.getPropertyValue("adp:stato")+"]");<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;pageNumber++;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if (!currentPage.getHasMoreItems())<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; finished = true;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<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></CODE></PRE><BR /><SPAN>thanks</SPAN></BODY></HTML> Fri, 16 Mar 2012 08:44:17 GMT mirko79 2012-03-16T08:44:17Z Opencmis extension paging problem https://connect.hyland.com/t5/alfresco-archive/opencmis-extension-paging-problem/m-p/276008#M229138 Hi,i'm having problems using pagination with opencmis extension : if the last page contains only one results the "currentPage.getHasMoreItems()" on second-last page returns false and i lose one result.For example if i set MaxItemPerPage to 10 and there are 21 results, the last is not retrieved.I hav Fri, 16 Mar 2012 08:44:17 GMT https://connect.hyland.com/t5/alfresco-archive/opencmis-extension-paging-problem/m-p/276008#M229138 mirko79 2012-03-16T08:44:17Z Re: Opencmis extension paging problem https://connect.hyland.com/t5/alfresco-archive/opencmis-extension-paging-problem/m-p/276009#M229139 <HTML><HEAD></HEAD><BODY><SPAN>Hi Mirko79,</SPAN><BR /><BR /><SPAN>have you solved this problem?</SPAN><BR /><SPAN>I've tried the same on a fresh 4.2.c community edition, same result, the last item is missing.</SPAN><BR /><SPAN>Then I tried using lucene and with it it works.</SPAN></BODY></HTML> Wed, 30 Jan 2013 16:22:26 GMT https://connect.hyland.com/t5/alfresco-archive/opencmis-extension-paging-problem/m-p/276009#M229139 steves 2013-01-30T16:22:26Z Re: Opencmis extension paging problem https://connect.hyland.com/t5/alfresco-archive/opencmis-extension-paging-problem/m-p/276010#M229140 <HTML><HEAD></HEAD><BODY><SPAN>Have the same issue here that the last item is missing</SPAN><BR /><BR /><BR /><SPAN>Georges Goebel</SPAN></BODY></HTML> Fri, 05 Jul 2013 16:51:09 GMT https://connect.hyland.com/t5/alfresco-archive/opencmis-extension-paging-problem/m-p/276010#M229140 goebel 2013-07-05T16:51:09Z Re: Opencmis extension paging problem https://connect.hyland.com/t5/alfresco-archive/opencmis-extension-paging-problem/m-p/276011#M229141 <HTML><HEAD></HEAD><BODY><SPAN>Hi, I'm having the same issue! there is no news ?</SPAN></BODY></HTML> Wed, 20 Nov 2013 10:42:03 GMT https://connect.hyland.com/t5/alfresco-archive/opencmis-extension-paging-problem/m-p/276011#M229141 mohcinew 2013-11-20T10:42:03Z