topic How to perform a Join on Nuxeo in Nuxeo Forum

How to perform a Join on Nuxeo

Dalal_ — Fri, 19 Jun 2015 11:09:38 GMT

I was looking for a way to use JOINS in Nuxeo, CMISQL seems to be the right solution, I found this link But I don't know how to use it. There's not much documentationn about CMISQL in the official documentation.

It would be appreciated if you could provide me with links or a simple example explaining how it works.

Re: How to perform a Join on Nuxeo

Florent_Guillau — Tue, 23 Jun 2015 15:09:41 GMT

What have you tried and what didn't work?

Re: How to perform a Join on Nuxeo

Alain_ESCAFFRE — Mon, 13 Jul 2015 17:04:26 GMT

JOINS are indeed enabled for CMISQL when the property

org.nuxeo.cmis.joins=true

respecting the following conditions:

repository uses VCS (ie use a rdbms for storing metadata, vs mongodb)
queries are done through VCS (the database), not Elasticsearch

It means that you won't be in the optimal architecture performance wise for executing your queries.

It may be a better option to "denormalize" part of your data either in the repository or just in the elasticsearch index. The latter approach is a design that will be genericised in the future in the Nuxeo Platform.