cmis query fails with join and contains(path)

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Member II

cmis query fails with join and contains(path)

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.cmisSmiley SurprisedbjectId = AV.cmisSmiley SurprisedbjectId

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.cmisSmiley SurprisedbjectId = AV.cmisSmiley SurprisedbjectId

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

It returns nothing.

Do you have any idea?

Version is Enterprise - 5.1.1 (r128754-b138)

Thanks,

1 Reply
Highlighted
Senior Member

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

Hi

I have tried to reproduce this without your custom model

 SELECT * FROM cmis:document as D join cm:titled as T on D.cmisSmiley SurprisedbjectId = T.cmisSmiley SurprisedbjectId 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