cmis query fails with join and contains(path)

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

staarkh

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 still the same with this path)

The following works too :

   SELECT * FROM cmis:document as D
   join blv:acteversion as AV on D.cmisbjectId = AV.cmisbjectId

It returns all the documents that are in cmis:document and blv:acteversion, ~600 documents

But when I try a query with the two conditions (the where and the join) :

   SELECT * FROM cmis:document as D

   join blv:acteversion as AV on D.cmisbjectId = AV.cmisbjectId

   where CONTAINS(D, 'PATH:"//."')

It returns nothing.

Do you have any idea?

Version is Enterprise - 5.1.1 (r128754-b138)

Thanks,

andy1

Hi

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