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.

Get Folders only under /Site

generic1

Hi,

I get all folders over CMIS with:

SELECT * FROM cmis:folder c
‍‍‍

Now I only will get folders under /Sites folder (and no sub folders of Folders under /Site). Is this possible and how?

Thanks a lot!
Generic1

Find more posts tagged with

Comments

afaust

Hello,

this is possible by using the IN_FOLDER selector in the WHERE clause of your query. "SELECT * FROM st:sites" will give you the /Sites directory and you can use the cmis

bjectId to fill the IN_FOLDER selector.
But if you are only interested in sites (the only folders under /Sites), the you can also just do a "SELECT * FROM st:site" to get all the sites (which should always only be contained in /Sites).

Regards
Axel

generic1

perfect! Thanks a lot!!

generic1

I would have another question on this issue.
If i execute

SELECT s.cmis:lastModificationDate, s.cmis:name, s.cmis:objectTypeId, s.cmis:createdBy, s.cmis:objectId, s.cmis:baseTypeId, s.cmis:description FROM st:site s‍

over CMIS workbench, I get all properties of the sites including "description".

If I set up the same request over SOAPUI:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns="http://docs.oasis-open.org/ns/cmis/messaging/200908/">
   <soapenv:Header>
      <wsse:Security soapenv:mustUnderstand="1" xmlns:wsse="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd">
         <wsse:UsernameToken wsu:Id="UsernameToken-666" xmlns:wsu="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd">
            <wsse:Username>admin</wsse:Username>
            <wsse:Password>pw</wsse:Password>
         </wsse:UsernameToken>
      </wsse:Security>
   </soapenv:Header>
   <soapenv:Body>
      <ns:query>
         <ns:repositoryId>12346be3-7faa-4c83-8eb0-432199012d30</ns:repositoryId>
         <ns:statement>SELECT s.cmis:description, s.cmis:lastModificationDate, s.cmis:name, s.cmis:objectTypeId, s.cmis:createdBy, s.cmis:objectId, s.cmis:baseTypeId FROM st:site s</ns:statement>
      </ns:query>
   </soapenv:Body>
</soapenv:Envelope>
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

than description is empty.
Does anyone know why?

Thanks a lot!!
Generic

afaust

Hello,

first of all, which URL are you using for the SOAP request? Alfresco 4.x has several URLs and depending on the specific URL you are using, there may be differences in the implementation that relate to this.

Also, speaking from personal preference: SOAP? Ugh… There is nothing better than the browser binding. I purposely "forgot" there are any other bindings at all.

Regards
Axel

generic1

Hi,

thanks a lot for the response! I use the URL

https://HOST/alfresco/cmisws/DiscoveryService‍

and I hade prefered using SOAP because my Alfresco Client can only handle XML and no JSON (otherwise I would change to REST).
Is there any other URL to invoke CMIS 1.1 instead of CMIS 1.0 over SOAP?

Thanks a lot,
Generic1

afaust

Hello,

unfortunately, it seems the SOAP endpoint is missing from the new Public API which should be used in 4.2 and above. See <a href="https://issues.alfresco.com/jira/browse/ACE-2468">ACE-2468</a>. The pattern of CMIS URLs to be used is outlined in that issue.

Regards
Axel