cmis query fails with join and contains(path)

staarkh — Tue, 29 Aug 2017 17:52:37 GMT

Hi,I have a problem with my cmis query, any help would be appreciated.The following query works : SELECT * FROM cmis:document as D where CONTAINS(D, 'PATH:"//."')It returns all the documents, 800 documents(Actually the Path is more complicated but I simplify here to illustrate, the problem is st

Re: cmis query fails with join and contains(path)

andy1 — Tue, 19 Sep 2017 11:56:20 GMT

I have tried to reproduce this without your custom model

SELECT * FROM cmis:document as D join cm:titled as T on D.cmisbjectId = T.cmisbjectId where CONTAINS(D, 'PATH:"//."')

This works as expected. The first and third queries will use SOLR; the second the database. I suggest that you configure the search sub-system to always use SOLR and go through the 3 queries again. There are a few things that could explain it.....

Are there any errors? Does the SUMMARY report have any model errors at the end?
Do the nodes have the hidden aspect applied?

http://localhost:8080/solr4/admin/cores?action=SUMMARY&wt=json

Andy

topic cmis query fails with join and contains(path) in Alfresco Forum

cmis query fails with join and contains(path)

Re: cmis query fails with join and contains(path)