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.

Retrieves tags in CMIS query

drahas

Hi

I'm using DotCMIS to access Alfresco documents and I want to retrieve documents and theirs tags in a query.
I have already done a simple query to retrieve my documents (SELECT d.* FROM cmis:document d WHERE IN_FOLDER('@folderID')) and it's working and after I call rest api to retrieve tags for each documents.
But I have some horrible performances for few documents, that is not possible …

Now I looking for a way to do it faster

I have found this query : select d.*, o.* from cmis:document as d join cm:taggable as o on d.cmis

bjectid = o.cmis

bjectid
But it doesn't work in my case, CMIS error.

Somebody have an idea how to do it ?

Find more posts tagged with

Comments

afaust

Hello,

please be aware that joining on secondary types in a CMIS query is only possible if you use the CMIS 1.1 compliant API of Alfresco. Alfresco supports both CMIS 1.0 and CMIS 1.1 with different URL endpoints and you need to be aware of which you use (also which type of binding).

Alfresco also had some support for joining on aspects in CMIS 1.0, but via a different approach that resulted in slightly different queries.

So, please retry and ensure you use a CMIS 1.1 endpoint. If you use the cmisbrowser binding, you are guaranteed to use CMIS 1.1 as that binding has been introduced with that version and didn't exist in 1.0.
Then, if you still have an error, you should add it in your post so others can give better guidance.

Regards
Axel

drahas

Thank you for your help AFaust.

I'm a little bit lost in this differents url for CMIS,
I'm using this url : "http://[host]:[port]/alfresco/service/cmis and my queries work fine, but I need to retrieve tags now.

According the documentation I tried this url : http://[host]:[port]/alfresco/api/-default-/public/cmis/versions/1.1/atom. It's ok, I have same results.
But the query for tags return a "Bad request" exception

Have you an idea what i'm doing wrong ? ?

afaust

You still haven't provided any details about the "Bad request" exception - typically there should be some kind of exception stack trace in either the logs or the HTTP response body, or at least an error message that states what part of the request is "bad".

The URL http://[host]:[port]/alfresco/service/cmis is a legacy endpoint from Alfresco 3.4 and should not be used. It has been removed in Alfresco 5.0. The URL http://[host]:[port]/alfresco/api/-default-/public/cmis/versions/1.1/atom and the other variant with /cmisbrowser are the proper, supported endpoints.

drahas

Thank you again AFaust. I'm now using the http://[host]:[port]/alfresco/api/-default-/public/cmis/versions/1.1/atom url.

But when I execute this query "select d.*, o.* from cmis:document as d join cm:taggable as o on d.cmis

bjectid = o.cmis

bjectid" with DotCMIS I have this error :

<html><head><title>Apache Chemistry OpenCMIS - invalidArgument error</title><style><!–H1 {font-size:24px;line-height:normal;font-weight:bold;background-color:#f0f0f0;color:#003366;border-bottom:1px solid #3c78b5;padding:2px;} BODY {font-family:Verdana,arial,sans-serif;color:black;font-size:14px;} HR {color:#3c78b5;height:1px;}–></style></head><body><h1>HTTP Status 400 - <!–exception–>invalidArgument<!–/exception–></h1><p><!–message–>Unknown column/property cmis:objectid<!–/message–></p><hr noshade='noshade'/><!–stacktrace–><pre>
org.apache.chemistry.opencmis.commons.exceptions.CmisInvalidArgumentException: Unknown column/property cmis:objectid
&nbsp;&nbsp;&nbsp;at org.alfresco.opencmis.search.CMISQueryParser.buildColumnReference(CMISQueryParser.java:1558)
&nbsp;&nbsp;&nbsp;at org.alfresco.opencmis.search.CMISQueryParser.buildSource(CMISQueryParser.java:1480)
&nbsp;&nbsp;&nbsp;at org.alfresco.opencmis.search.CMISQueryParser.parse(CMISQueryParser.java:138)
&nbsp;&nbsp;&nbsp;at org.alfresco.repo.search.impl.solr.DbCmisQueryLanguage.executeQueryImpl(DbCmisQueryLanguage.java:116)
&nbsp;&nbsp;&nbsp;at org.alfresco.repo.search.impl.solr.DbCmisQueryLanguage.executeQuery(DbCmisQueryLanguage.java:95)
&nbsp;&nbsp;&nbsp;at org.alfresco.repo.search.impl.solr.DbOrIndexSwitchingQueryLanguage.executeQuery(DbOrIndexSwitchingQueryLanguage.java:122)
&nbsp;&nbsp;&nbsp;at org.alfresco.repo.search.impl.solr.SolrOpenCMISQueryServiceImpl.query(SolrOpenCMISQueryServiceImpl.java:89)
&nbsp;&nbsp;&nbsp;at sun.reflect.GeneratedMethodAccessor6409.invoke(Unknown Source)
&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
&nbsp;&nbsp;&nbsp;at java.lang.reflect.Method.invoke(Method.java:606)
&nbsp;&nbsp;&nbsp;at org.alfresco.repo.management.subsystems.SubsystemProxyFactory$1.invoke(SubsystemProxyFactory.java:72)
&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
&nbsp;&nbsp;&nbsp;at com.sun.proxy.$Proxy144.query(Unknown Source)
&nbsp;&nbsp;&nbsp;at org.alfresco.opencmis.CMISConnector.query(CMISConnector.java:2779)
&nbsp;&nbsp;&nbsp;at org.alfresco.opencmis.AlfrescoCmisServiceImpl.query(AlfrescoCmisServiceImpl.java:2302)
&nbsp;&nbsp;&nbsp;at sun.reflect.GeneratedMethodAccessor6408.invoke(Unknown Source)
&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
&nbsp;&nbsp;&nbsp;at java.lang.reflect.Method.invoke(Method.java:606)
&nbsp;&nbsp;&nbsp;at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
&nbsp;&nbsp;&nbsp;at org.alfresco.repo.transaction.RetryingTransactionInterceptor$1.execute(RetryingTransactionInterceptor.java:79)
&nbsp;&nbsp;&nbsp;at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:452)
&nbsp;&nbsp;&nbsp;at org.alfresco.repo.transaction.RetryingTransactionInterceptor.invoke(RetryingTransactionInterceptor.java:69)
&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
&nbsp;&nbsp;&nbsp;at org.alfresco.opencmis.AlfrescoCmisStreamInterceptor.invoke(AlfrescoCmisStreamInterceptor.java:72)
&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
&nbsp;&nbsp;&nbsp;at org.alfresco.opencmis.AlfrescoCmisServiceInterceptor.invoke(AlfrescoCmisServiceInterceptor.java:101)
&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
&nbsp;&nbsp;&nbsp;at org.alfresco.opencmis.AlfrescoCmisExceptionInterceptor.invoke(AlfrescoCmisExceptionInterceptor.java:50)
&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
&nbsp;&nbsp;&nbsp;at com.sun.proxy.$Proxy369.query(Unknown Source)
&nbsp;&nbsp;&nbsp;at org.apache.chemistry.opencmis.server.support.CmisServiceWrapper.query(CmisServiceWrapper.java:1125)
&nbsp;&nbsp;&nbsp;at org.apache.chemistry.opencmis.server.impl.atompub.DiscoveryService$Query.serve(DiscoveryService.java:115)
&nbsp;&nbsp;&nbsp;at org.apache.chemistry.opencmis.server.shared.Dispatcher.dispatch(Dispatcher.java:88)
&nbsp;&nbsp;&nbsp;at org.apache.chemistry.opencmis.server.impl.atompub.CmisAtomPubServlet.dispatch(CmisAtomPubServlet.java:225)
&nbsp;&nbsp;&nbsp;at org.apache.chemistry.opencmis.server.impl.atompub.CmisAtomPubServlet.service(CmisAtomPubServlet.java:172)
&nbsp;&nbsp;&nbsp;at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
&nbsp;&nbsp;&nbsp;at org.alfresco.opencmis.CMISServletDispatcher.execute(CMISServletDispatcher.java:173)
&nbsp;&nbsp;&nbsp;at org.alfresco.opencmis.CMISWebScript.execute(CMISWebScript.java:51)
&nbsp;&nbsp;&nbsp;at org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecute(RepositoryContainer.java:377)
&nbsp;&nbsp;&nbsp;at org.alfresco.rest.api.PublicApiRepositoryContainer.transactionedExecute(PublicApiRepositoryContainer.java:45)
&nbsp;&nbsp;&nbsp;at org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecuteAs(RepositoryContainer.java:529)
&nbsp;&nbsp;&nbsp;at org.alfresco.repo.web.scripts.RepositoryContainer.executeScript(RepositoryContainer.java:341)
&nbsp;&nbsp;&nbsp;at org.alfresco.rest.api.PublicApiRepositoryContainer.access$001(PublicApiRepositoryContainer.java:26)
&nbsp;&nbsp;&nbsp;at org.alfresco.rest.api.PublicApiRepositoryContainer$1.doWork(PublicApiRepositoryContainer.java:81)
&nbsp;&nbsp;&nbsp;at org.alfresco.repo.tenant.TenantUtil.runAsWork(TenantUtil.java:119)
&nbsp;&nbsp;&nbsp;at org.alfresco.repo.tenant.TenantUtil.runAsTenant(TenantUtil.java:88)
&nbsp;&nbsp;&nbsp;at org.alfresco.rest.api.PublicApiRepositoryContainer.executeScript(PublicApiRepositoryContainer.java:77)
&nbsp;&nbsp;&nbsp;at org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:378)
&nbsp;&nbsp;&nbsp;at org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:209)
&nbsp;&nbsp;&nbsp;at org.alfresco.repo.web.scripts.TenantWebScriptServlet.service(TenantWebScriptServlet.java:74)
&nbsp;&nbsp;&nbsp;at org.alfresco.rest.api.PublicApiWebScriptServlet.service(PublicApiWebScriptServlet.java:53)
&nbsp;&nbsp;&nbsp;at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
&nbsp;&nbsp;&nbsp;at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
&nbsp;&nbsp;&nbsp;at org.alfresco.web.app.servlet.GlobalLocalizationFilter.doFilter(GlobalLocalizationFilter.java:61)
&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
&nbsp;&nbsp;&nbsp;at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
&nbsp;&nbsp;&nbsp;at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
&nbsp;&nbsp;&nbsp;at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)
&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
&nbsp;&nbsp;&nbsp;at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
&nbsp;&nbsp;&nbsp;at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1040)
&nbsp;&nbsp;&nbsp;at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)
&nbsp;&nbsp;&nbsp;at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:313)
&nbsp;&nbsp;&nbsp;at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
&nbsp;&nbsp;&nbsp;at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
&nbsp;&nbsp;&nbsp;at java.lang.Thread.run(Thread.java:724)

</pre><!–/stacktrace–><hr noshade='noshade'/></body></html>
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

I have no idea how I can try to debug it outside DotCMIS.

drahas

Thank you again AFaust.

I'm now using the http://[host]:[port]/alfresco/api/-default-/public/cmis/versions/1.1/atom url.

But this query doesn't work : select d.*, o.* from cmis:document as d join cm:taggable as o on d.cmis

bjectid = o.cmis

bjectid (see error in attachement)

I dont know how to debug Alfresco query

error_6.png

afaust

Well, the error message already includes everything you need to know: "Unknown column/property cmis

bjectid"
You simply have a typo in your query. You wrote cmis

bjectid instead of cmis

bjectId (capital i in Id) and that is not a valid column to query / join on.

drahas

Thank you Afaust,

I can now run this query correctly with alfresco rest service, but I have an error 500 when using DotCMIS (see attachement). Any idea ?

Now, I want to modify this query with adding an IN_FOLDER condition but I didn't find the good syntax.
I tried this : select d.*, o.* from cmis:document as d join cm:taggable as o on d.cmis

bjectId = o.cmis

bjectId where IN_FOLDER('workspace://SpacesStore/ed77ea8d-fac0-4fad-aecb-c29340afa482')
But I have an error 500 with alfresco rest (An error inside the HTTP server which prevented it from fulfilling the request).

Have you any tool which I can use to test my queries ?

error_7.png

afaust

Hello,

are there any logs for the error? The attached screenshot is not worth much unfortunately.
You can test CMIS queries via the Alfresco Node Browser tool in the Share UI (or in Alfresco 5.0.d and above in the Repository administration console UI).

Regards
Axel