topic Re: CMIS Association Query in Alfresco Archive

CMIS Association Query

albertogarcía — Fri, 03 Jul 2015 07:10:56 GMT

Hi,I have searched the way of making simple joins with CMIS in Alfresco, but can't find the way to write what I want.I have a custom model with an association like this<association name="actardenDia"> <title>Orden del dia</title> <target> <class>cm:conte

Re: CMIS Association Query

mrogers — Fri, 03 Jul 2015 12:59:18 GMT

Join is not supported on 4.2

Re: CMIS Association Query

albertogarcía — Mon, 06 Jul 2015 07:02:45 GMT

Hi mrogers,

I have executed some querys found in some examples, such as:
SELECT * FROM cmis:document d join cm:titled t on d.cmisbjectId = t.cmisbjectId

or (adapting it to my models)
SELECT * FROM cmis:document d join acta:acta t on d.cmisbjectId = t.cmisbjectId

And are working, but can't find the way to get the id of the document in the association for the query (instead of d.cmisbjectId, I need the associaton document ID).

Regards,
Alberto

Re: CMIS Association Query

sandeepreddy — Wed, 08 Jul 2015 11:10:02 GMT

Hi Mrogers,
Please help me i am facing timestamp error