topic Re: CMIS Query Language - Has not Aspect in Alfresco Archive

CMIS Query Language - Has not Aspect

castgroupteam — Mon, 26 Aug 2013 13:44:26 GMT

How can I query my Alfresco repository through CMIS Query Language asking for all nodes which does not implement a custom aspect?(Something like NOT hasAspect("my:customAspect")).Using the join syntax I can ask for nodes with all aspects I want but in this case I need to exclude nodes which has not

Re: CMIS Query Language - Has not Aspect

kaynezhang — Thu, 29 Aug 2013 06:13:38 GMT

I'm afraid there is no such feature in cmis query language,You can use lucene language.

Re: CMIS Query Language - Has not Aspect

kaynezhang — Thu, 29 Aug 2013 06:52:07 GMT

This is an lucene example that search nodes without aspect "cm:titled"
+PATH:"/app:company_home//." AND -ASPECT:"cm:titled"

Re: CMIS Query Language - Has not Aspect

castgroupteam — Fri, 30 Aug 2013 10:06:27 GMT

Thank you for your help, your answer is helpful for sure.
I know it's possible using lucene, ftl and so on, I think it is a common used feature so I found unbelievable was not implemented by the cmis layer.
I am building an external java application so I still want to use cmis, I've changed my logic in order to exclude by path instead that by aspect. (using NOT in_tree(…) cmis function).

Regards.
Daniele

Re: CMIS Query Language - Has not Aspect

castgroupteam — Fri, 04 Oct 2013 14:33:59 GMT

I found it's possible using CONTAINS(..) clause

Re: CMIS Query Language - Has not Aspect

iblanco — Mon, 21 Oct 2013 12:42:37 GMT

Could you please explain how did you achieve it using the CONTAINS clause ? AFAIK CONTAINS only searches in the content, is not related to aspects.

Re: CMIS Query Language - Has not Aspect

castgroupteam — Tue, 05 Nov 2013 17:26:00 GMT

That's not true, with cmis-alfresco you can use the CONTAINS construct to build query with mixed CMIS and FTS query syntax.

http://wiki.alfresco.com/wiki/CMIS_Query_Language#cmis-alfresco

Re: CMIS Query Language - Has not Aspect

castgroupteam — Mon, 11 Nov 2013 11:04:56 GMT

…AND CONTAINS(P,\'NOT ASPECT:\\\'test:myCustomAspecy\\\'\')

Re: CMIS Query Language - Has not Aspect

iblanco — Mon, 11 Nov 2013 14:39:12 GMT

I had read many times about CONTAINS in the wiki's Search page and never understood that this could be used this way. It's good to know it.

Thanks

Re: CMIS Query Language - Has not Aspect

kaynezhang — Mon, 11 Nov 2013 15:19:00 GMT

Good idea,using the contains() function in CMIS-SQL extremelly increase CMIS query capabilities

Re: CMIS Query Language - Has not Aspect

iblanco — Mon, 11 Nov 2013 16:40:34 GMT

You're right kaynezhang, it increases capabilities but be aware that this is out of the CMIS estándar so don't expect your code to work properly if ported to other CMIS compliant server.

Re: CMIS Query Language - Has not Aspect

kaynezhang — Tue, 12 Nov 2013 00:46:00 GMT

The CMIS interface is designed to be layered on top of existing Content Management systems and their existing programmatic interfaces. It is not intended to exhaustively expose all of the CM system's capabilities through the CMIS interfaces. So if we want to use CMIS interface ,we will lose some specific capabilities provided by a specicific CM system.If we wan to use some specific capabilities ,we still need to use CMIS extension or vendor specific api.
alfresco Aspects is alfresco specific feature( apsect is not include CMIS v1.0 specification ,Secondary object types are added in CMIS v1.1,but opencmis has not implemented yet ).
So I think it's ok to use cmis-alfresco query language.

Re: CMIS Query Language - Has not Aspect

castgroupteam — Tue, 12 Nov 2013 09:25:19 GMT

you are all right.
contains clause (cmis-alfresco) increase CMIS query capabilities but your code then cannot work properly if ported to other cmis compliant server.
In any case I think that if you have to integrate Alfresco with any other environements, cmis choice is the better (and easiest) solution.
In many cases it is not enough, for transaction based tasks, for example, cmis is not enough.