topic Re: OpenCmis Extension, trying to query custom Aspects in Alfresco Archive

OpenCmis Extension, trying to query custom Aspects

jba — Tue, 28 Jun 2011 11:55:44 GMT

Dear all,It's been quite a few weeks now I am breaking my teeth against that, so I thought I would ask the community.I have a custom made model looking roughly like this :<type name="re:doc"> <title>Document racine</title> <parent>cm:content</parent>

Re: OpenCmis Extension, trying to query custom Aspects

jpotts — Wed, 29 Jun 2011 15:54:36 GMT

Have you looked at this wiki page? It describes how to query for aspects. You have to do a join.

Jeff

Re: OpenCmis Extension, trying to query custom Aspects

jba — Fri, 01 Jul 2011 14:18:35 GMT

Thanks Jeff, I indeed overlooked those two lines - indeed doing something like this works without any error message

select d.*, o.* from cmis:document as d join re:webable as o on d.cmis:objectid = o.cmis:objectid‍

But how could I query a *property* of such an aspect be it a boolean like a re:isActive or -worse- a Category like in my sample below, this I couldn't find.

<aspect name="re:stport">
         <title>Structure porteuse</title>   
         <parent>cm:generalclassifiable</parent>
         <properties>
            <property name="re:stpor">
               <title>Structure porteuse</title>
               <type>d:category</type>
               <mandatory>false</mandatory>
            <multiple>false</multiple>
               <index enabled="true">
                      <atomic>true</atomic>
                      <stored>true</stored>
                      <tokenised>true</tokenised>
               </index>
            </property>
         </properties>
      </aspect>
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

really, any extra help appreciated !

Re: OpenCmis Extension, trying to query custom Aspects

jpotts — Wed, 06 Jul 2011 14:25:56 GMT

Here's an example using the sc:statusIndicator property of sc:statusable:

select d.*, o.* from cmis:document as d join sc:statusable as o on d.cmis:objectid = o.cmis:objectid where o.sc:statusIndicator = 'Green'‍

And here's an example using the sc:isActive property of sc:webable:

select d.*, o.* from cmis:document as d join sc:webable as o on d.cmis:objectid = o.cmis:objectid where o.sc:isActive = True‍

Category is more complicated. I think that may require a join if it is even possible at all.

If you haven't found it already, you might look into using the Apache Chemistry Workbench. It's a handy little Java Swing app that you can use to quickly test queries, run groovy scripts, or simply browse your CMIS repository.

Jeff

Re: OpenCmis Extension, trying to query custom Aspects

jba — Wed, 06 Jul 2011 18:18:26 GMT

Thanks SO much for helping Jeff
I will try using the Apache Chemistry Workbench as you suggest. If I ever find about Categories queries I will post it here
Thanks again
JB

Re: OpenCmis Extension, trying to query custom Aspects

jba — Fri, 28 Oct 2011 14:41:20 GMT

Sorry to unearth that old thread -I am still trying to query custom aspects and Joins work really well but I have an extra problem -how can I have (or make up like it actually exists) a query that works on *two* or *several* aspects ?

Actually while trying the code below -a double joint- I got that in the error message "Advanced join is not supported "

SELECT d.*, o.*,p.* FROM cmis:document AS d JOIN re:webable AS o ON d.cmis:objectid = o.cmis:objectid JOIN re:status AS p ON d.cmis:objectid = o.cmis:objectid WHERE o.re:isActive = True AND p.re:status='test'‍

So the questions would be
-can I actually query several aspects / aspects properties ?
- if yes, what's wrong in my code?
Thanks for looking
JB

PS error message

HTTP call to [http://localhost:8080/alfresco/service/cmis/queries] returned [500]. Response: Web Script Status 500 - Internal Error Web Script Status 500 - Internal Error The Web Script /alfresco/service/cmis/queries has responded with a status of 500 - Internal Error. 500 Description: An error inside the HTTP server which prevented it from fulfilling the request.   Message:09280016 Wrapped Exception (with status template): 09280033 Failed to execute script 'classpath*:alfresco/templates/webscripts/org/alfresco/cmis/queries.post.cmisquery.js': Advanced join is not supported   Exception:java.lang.UnsupportedOperationException - Advanced join is not supported   org.alfresco.repo.search.impl.querymodel.impl.lucene.LuceneQueryEngine.executeQuery(LuceneQueryEngine.java:132) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) java.lang.reflect.Method.invoke(Method.java:597) org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) net.sf.acegisecurity.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:80) org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) $Proxy113.executeQuery(Unknown Source) org.alfresco.cmis.search.CMISQueryServiceImpl.query(CMISQueryServiceImpl.java:128) org.alfresco.repo.cmis.rest.CMISScript.query(CMISScript.java:652) sun.reflect.GeneratedMethodAccessor649.invoke(Unknown Source) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) java.lang.reflect.Method.invoke(Method.java:597) org.mozilla.javascript.MemberBox.invoke(MemberBox.java:155) org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:243) org.mozilla.javascript.optimizer.OptRuntime.call2(OptRuntime.java:76) org.mozilla.javascript.gen.c2._c0(file:/H:/Alfresco/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/templates/webscripts/org/alfresco/cmis/queries.post.cmisquery.js:67) org.mozilla.javascript.gen.c2.call(file:/H:/Alfresco/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/templates/webscripts/org/alfresco/cmis/queries.post.cmisquery.js) org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:393) org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:2834) org.mozilla.javascript.gen.c2.call(file:/H:/Alfresco/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/templates/webscripts/org/alfresco/cmis/queries.post.cmisquery.js) org.mozilla.javascript.gen.c2.exec(file:/H:/Alfresco/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/templates/webscripts/org/alfresco/cmis/queries.post.cmisquery.js) org.alfresco.repo.jscript.RhinoScriptProcessor.executeScriptImpl(RhinoScriptProcessor.java:472) org.alfresco.repo.jscript.RhinoScriptProcessor.execute(RhinoScriptProcessor.java:190) org.alfresco.repo.processor.ScriptServiceImpl.executeScript(ScriptServiceImpl.java:282) org.alfresco.repo.web.scripts.RepositoryScriptProcessor.executeScript(RepositoryScriptProcessor.java:102) org.springframework.extensions.webscripts.AbstractWebScript.executeScript(AbstractWebScript.java:981) org.springframework.extensions.webscripts.DeclarativeWebScript.execute(DeclarativeWebScript.java:86) org.alfresco.repo.web.scripts.RepositoryContainer$2.execute(RepositoryContainer.java:377) org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:381) org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecute(RepositoryContainer.java:436) org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecuteAs(RepositoryContainer.java:466) org.alfresco.repo.web.scripts.RepositoryContainer.executeScript(RepositoryContainer.java:304) org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:333) org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:189) org.springframework.extensions.webscripts.servlet.WebScriptServlet.service(WebScriptServlet.java:118) javax.servlet.http.HttpServlet.service(HttpServlet.java:717) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) org.alfresco.web.app.servlet.GlobalLocalizationFilter.doFilter(GlobalLocalizationFilter.java:58) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:861) org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:579) org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1584) java.lang.Thread.run(Thread.java:662)   Exception:org.alfresco.scripts.ScriptException - 09280033 Failed to execute script 'classpath*:alfresco/templates/webscripts/org/alfresco/cmis/queries.post.cmisquery.js': Advanced join is not supported   org.alfresco.repo.jscript.RhinoScriptProcessor.execute(RhinoScriptProcessor.java:194)   Exception:org.springframework.extensions.webscripts.WebScriptException - 09280016 Wrapped Exception (with status template): 09280033 Failed to execute script 'classpath*:alfresco/templates/webscripts/org/alfresco/cmis/queries.post.cmisquery.js': Advanced join is not supported   org.springframework.extensions.webscripts.AbstractWebScript.createStatusException(AbstractWebScript.java:758)   Server:Community v3.4.0 (e 3419) schema 4 113 Time:28 oct. 2011 16:31:10   Diagnostics:Inspect Web Script (org/alfresco/cmis/queries.post) ‍

Re: OpenCmis Extension, trying to query custom Aspects

sindhu — Thu, 29 Aug 2013 13:05:11 GMT

I have created custom object types in alfresco and I could use it directly through UI too. But,I am not getting any records or even errors while querying through the custom object types.Please let me know what could be wrong..

Re: OpenCmis Extension, trying to query custom Aspects

kaynezhang — Thu, 29 Aug 2013 15:37:43 GMT

How did you query through your custom object types? in what search language? what is your search string?

Re: OpenCmis Extension, trying to query custom Aspects

loulinyuan — Mon, 16 Dec 2013 17:39:51 GMT

With a query similar to "select d.*, o.* from cmis:document as d join sc:statusable as o on d.cmisbjectid = o.cmisbjectid where o.sc:statusIndicator = 'Green'", I could get a list of CmisObject (myObj) back, from which I could use myObj.getName() and myObj.getId() to retrieve the document name and object id. However, myObj.getPolicies() returns null, even though I could see the values of the properties in Alfresco Share. Can you please advise how to retrieve properties values for an aspect that has been applied to a document using OpenCMIS?

Re: OpenCmis Extension, trying to query custom Aspects

jpotts — Wed, 08 Jan 2014 22:09:12 GMT

Using OpenCMIS and the <a href="http://code.google.com/a/apache-extras.org/p/alfresco-opencmis-extension/">Alfresco Extension for OpenCMIS</a> you can do this:


      if (!doc.hasAspect("P:cm:geographic")) {
         doc.addAspect("P:cm:geographic");
         System.out.println("Added aspect");
      } else {
         System.out.println("Doc already had aspect");
      }
      
      HashMap<String, Object> props = new HashMap<String, Object>();
      props.put("cm:latitude", 52.513871);
      props.put("cm:longitude", 13.391106);      
      doc.updateProperties(props);
      
      System.out.println("Latitude: " + doc.getProperty("cm:latitude").getValueAsString());
      System.out.println("Longitude: " + doc.getProperty("cm:longitude").getValueAsString());
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Retrieving property values defined in an aspect is no different than retrieving values defined in a type when you are using the OpenCMIS extension.

Jeff