topic Re: query by jointing multiple aspects in Alfresco Archive

query by jointing multiple aspects

nick_l — Fri, 19 Apr 2013 06:50:48 GMT

I have a situation which requires query over multiple aspects. I can find examples which join cmis:document and cm:some_aspects, such as "select t.*, d.* from cmis:document as d join cm:author as t on d.cmisbjectid = t.cmisbjectid where t.cm:author='ianrankin' "The question is how to join multip

Re: query by jointing multiple aspects

ecarbenay — Fri, 19 Apr 2013 07:35:43 GMT

You can join multiple aspects like this :

select t.*, d.*, e.* from cmis:document as d
join cm:author as t on d.cmisbjectId = t.cmisbjectId
join exif:exif e on d.cmisbjectId = e.cmisbjectId
where t.cm:author='Emmanuel Carbenay'
and e.exif:manufacturer = 'Canon'

Simply chain your JOIN predicates

Emmanuel

Re: query by jointing multiple aspects

nick_l — Sun, 21 Apr 2013 23:59:33 GMT

Hi Emmanuel,

That's exactly what I tried before I posted this question. But I got exception as below:

org.apache.chemistry.opencmis.commons.exceptions.CmisInvalidArgumentException: No selector for
   at org.apache.chemistry.opencmis.client.bindings.spi.atompub.AbstractAtomPubService.convertStatusCode(AbstractAtomPubService.java:423)
   at org.apache.chemistry.opencmis.client.bindings.spi.atompub.AbstractAtomPubService.post(AbstractAtomPubService.java:570)
   at org.apache.chemistry.opencmis.client.bindings.spi.atompub.DiscoveryServiceImpl.query(DiscoveryServiceImpl.java:142)
   at au.com.SearchService.searchDocsFromRepository(SearchService.java:132)

Re: query by jointing multiple aspects

nick_l — Mon, 22 Apr 2013 00:55:52 GMT

rechecking my code and found I made a simple mistake. the join works fine, but when I compose the where condition, I forget to use the alias.

So problem solved.