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 query, cmis:path in WHERE clause

http

Hi all,

I'm using the CMIS query language. A basic query like

SELECT * FROM cmis:folder WHERE cmis:name='dataLists'‍

works fine.

However, when querying the cmisath property, I get an Internal Server error.

SELECT * FROM cmis:folder WHERE cmis:path='dataLists'‍

I expect the above query to return 0 resutls, instead I see an exception in the logs:

11:01:46,065 DEBUG [org.alfresco.repo.jscript.RhinoScriptProcessor] Time to execute script: 6.942148ms
11:01:46,066 ERROR [org.springframework.extensions.webscripts.AbstractRuntime] Exception from executeScript - redirecting to status template error: 03050036 Wrapped Exception (with status template): 03057978 Failed to execute script 'classpath*:alfresco/templates/webscripts/org/alfresco/cmis/queries.post.cmisquery.js': 03057977 Request failed 500 /solr/alfresco/cmis?q=SELECT+cmis%3Apath+FROM+cmis%3Afolder+WHERE+cmis%3Apath+%3D+%27dataLists%27&wt=json&fl=*%2Cscore&rows=2147483647&df=TEXT&start=0&locale=en_US&fq=%7B%21afts%7DAUTHORITY_FILTER_FROM_JSON&fq=%7B%21afts%7DTENANT_FILTER_FROM_JSON
org.springframework.extensions.webscripts.WebScriptException: 03050036 Wrapped Exception (with status template): 03057978 Failed to execute script 'classpath*:alfresco/templates/webscripts/org/alfresco/cmis/queries.post.cmisquery.js': 03057977 Request failed 500 /solr/alfresco/cmis?q=SELECT+cmis%3Apath+FROM+cmis%3Afolder+WHERE+cmis%3Apath+%3D+%27dataLists%27&wt=json&fl=*%2Cscore&rows=2147483647&df=TEXT&start=0&locale=en_US&fq=%7B%21afts%7DAUTHORITY_FILTER_FROM_JSON&fq=%7B%21afts%7DTENANT_FILTER_FROM_JSON
&nbsp;&nbsp;&nbsp;at org.springframework.extensions.webscripts.AbstractWebScript.createStatusException(AbstractWebScript.java:970)
&nbsp;&nbsp;&nbsp;at org.springframework.extensions.webscripts.DeclarativeWebScript.execute(DeclarativeWebScript.java:171)
&nbsp;&nbsp;&nbsp;at org.alfresco.repo.web.scripts.RepositoryContainer$2.execute(RepositoryContainer.java:393)
&nbsp;&nbsp;&nbsp;at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:388)
&nbsp;&nbsp;&nbsp;at org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecute(RepositoryContainer.java:462)
&nbsp;&nbsp;&nbsp;at org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecuteAs(RepositoryContainer.java:500)
&nbsp;&nbsp;&nbsp;at org.alfresco.repo.web.scripts.RepositoryContainer.executeScript(RepositoryContainer.java:316)
&nbsp;&nbsp;&nbsp;at org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:372)
&nbsp;&nbsp;&nbsp;at org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:209)
&nbsp;&nbsp;&nbsp;at org.springframework.extensions.webscripts.servlet.WebScriptServlet.service(WebScriptServlet.java:118)
&nbsp;&nbsp;&nbsp;at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
&nbsp;&nbsp;&nbsp;at org.alfresco.web.app.servlet.GlobalLocalizationFilter.doFilter(GlobalLocalizationFilter.java:58)
&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
&nbsp;&nbsp;&nbsp;at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:470)
&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
&nbsp;&nbsp;&nbsp;at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
&nbsp;&nbsp;&nbsp;at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
&nbsp;&nbsp;&nbsp;at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
&nbsp;&nbsp;&nbsp;at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
&nbsp;&nbsp;&nbsp;at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
&nbsp;&nbsp;&nbsp;at java.lang.Thread.run(Thread.java:662)
Caused by: org.alfresco.scripts.ScriptException: 03057978 Failed to execute script 'classpath*:alfresco/templates/webscripts/org/alfresco/cmis/queries.post.cmisquery.js': 03057977 Request failed 500 /solr/alfresco/cmis?q=SELECT+cmis%3Apath+FROM+cmis%3Afolder+WHERE+cmis%3Apath+%3D+%27dataLists%27&wt=json&fl=*%2Cscore&rows=2147483647&df=TEXT&start=0&locale=en_US&fq=%7B%21afts%7DAUTHORITY_FILTER_FROM_JSON&fq=%7B%21afts%7DTENANT_FILTER_FROM_JSON
&nbsp;&nbsp;&nbsp;at org.alfresco.repo.jscript.RhinoScriptProcessor.execute(RhinoScriptProcessor.java:195)
&nbsp;&nbsp;&nbsp;at org.alfresco.repo.processor.ScriptServiceImpl.execute(ScriptServiceImpl.java:212)
&nbsp;&nbsp;&nbsp;at org.alfresco.repo.processor.ScriptServiceImpl.executeScript(ScriptServiceImpl.java:174)
&nbsp;&nbsp;&nbsp;at org.alfresco.repo.web.scripts.RepositoryScriptProcessor.executeScript(RepositoryScriptProcessor.java:102)
&nbsp;&nbsp;&nbsp;at org.springframework.extensions.webscripts.AbstractWebScript.executeScript(AbstractWebScript.java:1193)
&nbsp;&nbsp;&nbsp;at org.alfresco.repo.cmis.rest.CMISWebScript.executeScript(CMISWebScript.java:46)
&nbsp;&nbsp;&nbsp;at org.springframework.extensions.webscripts.DeclarativeWebScript.execute(DeclarativeWebScript.java:86)
&nbsp;&nbsp;&nbsp;… 25 more
Caused by: org.alfresco.repo.search.impl.lucene.LuceneQueryParserException: 03057977 Request failed 500 /solr/alfresco/cmis?q=SELECT+cmis%3Apath+FROM+cmis%3Afolder+WHERE+cmis%3Apath+%3D+%27dataLists%27&wt=json&fl=*%2Cscore&rows=2147483647&df=TEXT&start=0&locale=en_US&fq=%7B%21afts%7DAUTHORITY_FILTER_FROM_JSON&fq=%7B%21afts%7DTENANT_FILTER_FROM_JSON
&nbsp;&nbsp;&nbsp;at org.alfresco.repo.search.impl.solr.SolrQueryHTTPClient.executeQuery(SolrQueryHTTPClient.java:333)
&nbsp;&nbsp;&nbsp;at org.alfresco.repo.search.impl.solr.SolrQueryLanguage.executeQuery(SolrQueryLanguage.java:49)
&nbsp;&nbsp;&nbsp;at org.alfresco.repo.search.impl.solr.SolrCMISQueryServiceImpl.query(SolrCMISQueryServiceImpl.java:93)
&nbsp;&nbsp;&nbsp;at sun.reflect.GeneratedMethodAccessor830.invoke(Unknown Source)
&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
&nbsp;&nbsp;&nbsp;at java.lang.reflect.Method.invoke(Method.java:597)
&nbsp;&nbsp;&nbsp;at org.alfresco.repo.management.subsystems.SubsystemProxyFactory$1.invoke(SubsystemProxyFactory.java:65)
&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 $Proxy140.query(Unknown Source)
&nbsp;&nbsp;&nbsp;at org.alfresco.repo.cmis.rest.CMISScript.query(CMISScript.java:683)
&nbsp;&nbsp;&nbsp;at sun.reflect.GeneratedMethodAccessor829.invoke(Unknown Source)
&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
&nbsp;&nbsp;&nbsp;at java.lang.reflect.Method.invoke(Method.java:597)
&nbsp;&nbsp;&nbsp;at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:155)
&nbsp;&nbsp;&nbsp;at org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:243)
&nbsp;&nbsp;&nbsp;at org.mozilla.javascript.optimizer.OptRuntime.call2(OptRuntime.java:76)
&nbsp;&nbsp;&nbsp;at org.mozilla.javascript.gen.c16._c0(file:/opt/alfresco-4.0.d/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/templates/webscripts/org/alfresco/cmis/queries.post.cmisquery.js:67)
&nbsp;&nbsp;&nbsp;at org.mozilla.javascript.gen.c16.call(file:/opt/alfresco-4.0.d/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/templates/webscripts/org/alfresco/cmis/queries.post.cmisquery.js)
&nbsp;&nbsp;&nbsp;at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:393)
&nbsp;&nbsp;&nbsp;at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:2834)
&nbsp;&nbsp;&nbsp;at org.mozilla.javascript.gen.c16.call(file:/opt/alfresco-4.0.d/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/templates/webscripts/org/alfresco/cmis/queries.post.cmisquery.js)
&nbsp;&nbsp;&nbsp;at org.mozilla.javascript.gen.c16.exec(file:/opt/alfresco-4.0.d/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/templates/webscripts/org/alfresco/cmis/queries.post.cmisquery.js)
&nbsp;&nbsp;&nbsp;at org.alfresco.repo.jscript.RhinoScriptProcessor.executeScriptImpl(RhinoScriptProcessor.java:483)
&nbsp;&nbsp;&nbsp;at org.alfresco.repo.jscript.RhinoScriptProcessor.execute(RhinoScriptProcessor.java:191)
&nbsp;&nbsp;&nbsp;… 31 more
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Probably, I'm doing something wrong. Can you please point out my mistake?

I'd like to do a query to find a node with a given path, e.g. /Sites/mysite/dataLists

Find more posts tagged with

Comments

mitpatoliya

that is because in that query with WHERE clause you can only use the queryable properties.Where cmis

ath is not one of those property.

http

thanks for pointing this out. i've overlooked this in the documentation: http://wiki.alfresco.com/wiki/CMIS_Query_Language#cmis:folder

is there a way to query cmisath using CONTAINS() ?

andy

Hi

You can use the standard Alfrecso path ueing

….CONTAINS('PATH:"//."')

Andy

http

Hi Andy,

a query for CONTAINS('PATH:"//."') returns all repository items, indeed.
how do I query for the repository item with a certain path, say /Sites/mysite/documentLibrary/MyFolder ?

as far as i can understand the documentation, the PATH queries are for querying the type of objects (as opposed to their cmis

ath property) http://wiki.alfresco.com/wiki/Search#Path_Queries

thanks,
gabor

mitpatoliya

No, I think you get it wrong.
Path Queries are to narrow down the search at particular location.
You can get all the documents residing under particular path using path query.

Generally this path query is user along with other property based query and aspect based query.
Hope this is clear now.

http

I was not able to narrow down the search by path.
Looking for all folders within MyFolder with the path /Sites/mysite/documentLibrary/MyFolder.

SELECT * FROM cmis:folder WHERE CONTAINS('PATH:"/Sites/mysite/documentLibrary/MyFolder"')‍

The above query returns no results.
Probably I'm getting the syntax within the CONTAINS predicate wrong.

How do I query for folders located below a certain path?

Would I have the the objectId of MyFolder, I could use IN_FOLDER or IN_TREE predicates. However, I have to query based on path.

thanks in advance,
gabor

andy

Hi

You can use the node browser in share to get the PATH. It will be something like:

/app:company_home/st:sites/cm:swsdp/cm:documentLibrary/cm

resentations

with ISO 9075 escaping as required for the path elements

Andy

johnny_k

Hello Andy
Can u tell me how i can get all folder from site
and other query all files in folder
i am trying use somethink like SELECT * FROM cmis:folder WHERE CONTAINS('PATH:"/Sites/mysite/documentLibrary/MyFolder"')
but i get only empty table

johnny_k

SELECT * FROM cmis:folder WHERE CONTAINS('PATH:"//app:company_home/st:sites/cm:NameSite/cm:documentLibrary/*"')

Solution of my question

)