AnsweredAssumed Answered

cmis query fails with join and contains(path)

Question asked by staarkh on Aug 29, 2017
Latest reply on Sep 19, 2017 by andy1

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.cmis:objectId = AV.cmis:objectId

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.cmis:objectId = AV.cmis:objectId

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

It returns nothing.

 

Do you have any idea?

 

Version is Enterprise - 5.1.1 (r128754-b138)

 

Thanks,

Outcomes