How to perform a Join on Nuxeo
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.
0 votes
1 answers
2375 views
Florent Guillaume
What have you tried and what didn't work?
06/23/2015
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.
 |
Alain ESCAFFRE
Director of Product Management (5.6K) 2 5 7 |
07/13/2015 ( History) |