topic Re: CMIS QL - get documents by path in Alfresco Archive

CMIS QL - get documents by path

iv0id — Mon, 09 Jun 2014 14:50:28 GMT

Hi ,Is there a way to get all documents in a path like "/MyDocs/<strong>anything_here</strong>/Published/<strong>anything_here</strong>" using CMIS QL or passing it as an argument to the getObjectByPath of the Session class?Thank you.

Re: CMIS QL - get documents by path

kaynezhang — Mon, 09 Jun 2014 15:28:56 GMT

You can use alfresco cmis path query ,like this


SELECT * FROM cmis:document D WHERE CONTAINS(D,'PATH: "/app:company_home//*"')
‍‍‍

Re: CMIS QL - get documents by path

iv0id — Mon, 09 Jun 2014 15:36:03 GMT

I have already tried it and it's not working. In log console i got this error :

org.alfresco.scripts.ScriptException - 05090198 Failed to execute script 'classpath*:alfresco/templates/webscripts/org/alfresco/cmis/queries.post.cmisquery.js': 05090197 Unknown column/property PATH‍

any idea ?

Re: CMIS QL - get documents by path

kaynezhang — Mon, 09 Jun 2014 16:13:15 GMT

The query statement I pasted out should work.
Could you paste your code here?

Re: CMIS QL - get documents by path

iv0id — Mon, 09 Jun 2014 16:30:32 GMT

i'm using CMIS Workbench to test the queries (i get the error i posted) and here is the java Code :


public Session getSession(String repositoryUrl, String user, String password){
   Session session = cacheSession.getIfPresent(user);
   if (session == null) {
      Map<String, String> sessionParameters = new HashMap<String, String>();
      sessionParameters.put(SessionParameter.USER, user);
      sessionParameters.put(SessionParameter.PASSWORD, password);
      sessionParameters.put(SessionParameter.ATOMPUB_URL, repositoryUrl + "/service/cmis");
      sessionParameters.put(SessionParameter.BINDING_TYPE, BindingType.ATOMPUB.value());
      sessionParameters.put(SessionParameter.OBJECT_FACTORY_CLASS,"org.alfresco.cmis.client.impl.AlfrescoObjectFactoryImpl");
      try {
         SessionFactory sessionFactory = SessionFactoryImpl.newInstance();
         session = sessionFactory.getRepositories(sessionParameters).get(0).createSession();
      } catch (CmisBaseException e) {
          //TODO
      }
      cacheSession.put(user, session);
   }
   return session;
}

// somewhere in the code 
ItemIterable<QueryResult> qrs = getSession("url","user","pwd").query("SELECT * FROM cmis:document D WHERE CONTAINS(D,'PATH: \"/app:company_home//*\"')", false);
for(QueryResult q : qrs) {
       System.out.println(q.getPropertyByQueryName("cmis:name"));
}
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

i get the error


org.apache.chemistry.opencmis.commons.exceptions.CmisRuntimeException: Erreur Interne de Servlet
   at org.apache.chemistry.opencmis.client.bindings.spi.atompub.AbstractAtomPubService.convertStatusCode(AbstractAtomPubService.java:452)
   at org.apache.chemistry.opencmis.client.bindings.spi.atompub.AbstractAtomPubService.post(AbstractAtomPubService.java:570)
   at org.apache.chemistry.opencmis.client.bindings.spi.atompub.DiscoveryServiceImpl.query(DiscoveryServiceImpl.java:142)
   at org.apache.chemistry.opencmis.client.runtime.SessionImpl$3.fetchPage(SessionImpl.java:557)
   at org.apache.chemistry.opencmis.client.runtime.util.AbstractIterator.getCurrentPage(AbstractIterator.java:132)
   at org.apache.chemistry.opencmis.client.runtime.util.CollectionIterator.hasNext(CollectionIterator.java:48)
   at com.sqli.sante.ged.alfresco.document.service.AlfrescoDocumentServiceImpl.main(AlfrescoDocumentServiceImpl.java:729)
‍‍‍‍‍‍‍‍‍‍

Re: CMIS QL - get documents by path

kaynezhang — Mon, 09 Jun 2014 17:01:16 GMT

ATOMPUB_URL url should be


http://localhost:8080/alfresco/cmisatom for 1.0
http://localhost:8080/alfresco/api/-default-/public/cmis/versions/1.1/atom for 1.1
‍‍‍‍

Re: CMIS QL - get documents by path

iv0id — Mon, 09 Jun 2014 17:26:10 GMT

i'm using Alfresco 3.4.d and i can successfully get the session by using the URL provided in the java code (http://localhost:8080/alfresco/service/cmis). I installed a new instance of alfresco 3.4.d and i'm still getting the error

Re: CMIS QL - get documents by path

kaynezhang — Mon, 09 Jun 2014 23:52:45 GMT

I'm using 4.2 ,and the following code works fine ,you can test it in your environment


      String serverUrl= "http://localhost:8080/alfresco/cmisatom";
      String userName = "admin";
      String password = "admin";
      SessionFactory sessionFactory = SessionFactoryImpl.newInstance();
      Map<String, String> params = new HashMap<String, String>();
      params.put(SessionParameter.USER, userName);
      params.put(SessionParameter.PASSWORD, password);
      params.put(SessionParameter.ATOMPUB_URL, serverUrl);
      params.put(SessionParameter.BINDING_TYPE, BindingType.ATOMPUB.value());
      params.put(SessionParameter.OBJECT_FACTORY_CLASS,
            "org.alfresco.cmis.client.impl.AlfrescoObjectFactoryImpl");
      List<Repository> repos = sessionFactory.getRepositories(params);
      if (repos.isEmpty()) {
         throw new RuntimeException("Server has no repositories!");
      }

      Session session =  repos.get(0).createSession();

      ItemIterable<QueryResult> qrs = session.query("SELECT * FROM cmis:document D WHERE CONTAINS(D,'PATH: \"/app:company_home//*\"')", false);

      for(QueryResult q : qrs) {
             System.out.println(q.getPropertyValueById(PropertyIds.OBJECT_ID));
             System.out.println(q.getPropertyValueById(PropertyIds.NAME));

      }
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: CMIS QL - get documents by path

iv0id — Tue, 10 Jun 2014 07:42:31 GMT

I tested the query in 4.2 instance and its working fine, but for now upgrading from 3.4 to 4.2 is not possible. If there is any workaround i'll be very thankful.
thank you for your time.

Re: CMIS QL - get documents by path

kaynezhang — Tue, 10 Jun 2014 08:40:00 GMT

I'm sorry I don't have 3.4 environment.I can't recreate your problem.

Re: CMIS QL - get documents by path

iv0id — Tue, 10 Jun 2014 13:12:00 GMT

Maybe be we have to consider upgrading to a newer version. thank you again for your replies.