nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

CMIS QL - get documents by path

iv0id

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.

Find more posts tagged with

Comments

kaynezhang

You can use alfresco cmis path query ,like this

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

iv0id

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 ?

kaynezhang

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

iv0id

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)
‍‍‍‍‍‍‍‍‍‍

kaynezhang

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
‍‍‍‍

iv0id

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

kaynezhang

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));

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

iv0id

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.

kaynezhang

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

iv0id

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