topic Efficient CMIS query for nodes with optional aspects in Alfresco Archive

Efficient CMIS query for nodes with optional aspects

pco — Mon, 29 Sep 2014 09:21:47 GMT

Hi, folks,I am trying to create a small groovy app with OpenCMIS and Alfresco Community 5.0.a as the backend (so CMIS 1.1 :-)I experienced quick progress during the first weeks with Alfresco (Content Modelling, customizations) and OpenCMIS APIs. Having arrived on the fine-tuning level some questions

Re: Efficient CMIS query for nodes with optional aspects

iv0id — Tue, 30 Sep 2014 10:02:16 GMT

Hi pco,

i've also encountered this case and for now i'm using the second solution (load the hole CmisObject) since the search results in my case don't exceed 10 items. I hope that the next versions will implement the outer joins

Re: Efficient CMIS query for nodes with optional aspects

pco — Thu, 02 Oct 2014 07:49:03 GMT

Hi, iv0id,

thanks for your reply, then it seems to be the right way to do it at the moment. Let's hope for outer JOIN. Probably I'll try to explore the cmis server code once I have some spare time.

In fact, I also had a little "weird" Idea yesterday: Create one aspect that contains all Fields of all my optional aspects as non-mandatory and protected (AspectsCarbonCopyAspect) and then basically write a custom Behaviour that updates the CC aspect's fields upon property changes on the original aspects. The query then is an inner join of cmis:document and the CC aspect.
This would resolve the problem but I do not feel very comfortable polluting the entire repository with redundant information just because of a "lack of flexibility". So I'll also stick with #2 (or #4 to be precise, ehcache does not hurt).

Have a great day