CMIS Association Query

[albertogarcía]

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:content</class>
        <mandatory>false</mandatory>
        <many>true</many>
      </target>
</association>

When I get the node, i can normally access to the assocition, get the documents… but now I want to make a query like:

select * from acta:acta a join cm:content c on a.actardenDia = c.cmisbjectID where (some conditions from both parts)

I can't get the way to do the query.

¿Any ideas? Thanks in advance for the help

Alberto

[mrogers]

Join is not supported on 4.2

[sandeepreddy]

Hi Mrogers,
Please help me i am facing timestamp error

[albertogarcía]

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