Join Query with Custom Aspects ?

dark_rider — Mon, 31 Jan 2011 10:12:53 GMT

How could I perform to join custom aspects with cmis query?this sql statement is working: SELECT D.*, O.* FROM cmis:document AS D JOIN cmwnable AS O ON D.cmisbjectId = O.cmisbjectIdBut when the tables are our custom apects, it is not working. Is there any way to join them?

Re: Join Query with Custom Aspects ?

andy — Mon, 31 Jan 2011 21:09:19 GMT

Hi

As far as I understand it, custom aspects should be available to the CMIS data model and anything that extemds content and folder. What happens? Do you get an error or no results?
If the type or property is unknown it should throw an error at query time (try an unknown aspect or type).

So to get any further you need to provide:
1) Some basic details of the aspect and properties it holds (thier types etc)
2) the query
3) a desciption of why it does not work - error no results
4) if you get no results, confirm the node has the aspect you expect and the properties you expect
5) Check you can do what you want.
Alfresco only supports self joining to aspects on the objects selected in the type (not a real join) - it allows you to make available the additional properties on the nodes pulled back
Each row in the results set only represents one node, not more.

Andy

topic Join Query with Custom Aspects ? in Alfresco Archive

Join Query with Custom Aspects ?

Re: Join Query with Custom Aspects ?