topic Re: Pagination CMIS query results in Alfresco Archive

Pagination CMIS query results

agz — Thu, 30 May 2013 16:08:47 GMT

Hi all,I'm working with Alfresco Community 4.0.e through CMIS.In a Java class I have a query that find all documents in a specified folderELECT *FROM cmis:document WHERE IN_FOLDER('workspace://SpacesStore/d588e663-7dc4-48b2-be8e-b6044584f769')‍‍‍‍‍this query give mi 28 results and I want to have p

Re: Pagination CMIS query results

goebel — Fri, 05 Jul 2013 16:48:33 GMT

Hi

Today it ran into the same Problem. After losing lot of time in debugging an googling, I managed to get it working but I still do not know if it's the right way (or solution)

How do you create you session ? Do you use an url like "http://alfrescoServer:8080/alfresco/s/cmis" ? I had exactly the same problem you had when I was using such an URL to create my session. After changing it to "http://alfrescoServer:8080/alfresco/cmisatom", the same code worked for me. (Which is according to alfresco help the 'alfresco open cmis extension')
In all the cmis documention on alfresco wiki and examples, I only found the alfresco/s/cmis url. So I am still a little concerned if I should use the cmisatom extension

Let me hear if that fixed your problem too.

Georges Goebel

Re: Pagination CMIS query results

chayiadp — Thu, 04 Sep 2014 09:52:51 GMT

I solve the problem. i know the post is old but it's possible it helps someone
Sorry for my english

   OperationContext tmpOperationContext = new OperationContextImpl();
      int numRowsPage = 2;
      tmpOperationContext.setMaxItemsPerPage(numRowsPage);
      String tmpQuery = "SELECT " + PropertyIds.NAME + " FROM cmis:document";
      ItemIterable<QueryResult> tmpResults = aSession.query(tmpQuery, true, tmpOperationContext);

      int count= 0;

      while(tmpResults.skipTo(count*numRowsPage).getHasMoreItems()){
         ItemIterable<QueryResult> tmpPage = tmpResults.skipTo(count*numRowsPage).getPage();
         count++;
         for(QueryResult tmpRegistro: tmpPage) {
            System.out.println(tmpRegistro.getPropertyById(PropertyIds.NAME).getFirstValue());
         }
      }

Re: Pagination CMIS query results

chayiadp — Thu, 04 Sep 2014 09:52:52 GMT