LIKE operator doesn't work on SharePoint2010 cmis query

Question

I was doing the cmis query testing against sharepoint repository. The general query looks fine such as '=' operator

SELECT cmis:name FROM cmis:document WHERE cmis:name = 'DesignDoc1.docs' 

but the query with LIKE operator doesn't work:

SELECT cmis:name FROM cmis:document WHERE cmis:name LIKE 'DesignDoc%' 

It threw an exception after executing the cmis query 

org.apache.chemistry.opencmis.commons.exceptions.CmisInvalidArgumentException: One or more of the input parameters to the service method is missing or invalid. 

If I changed the query like this:

SELECT * FROM cmis:document WHERE CONTAINS('DesignDoc*')

There isn't any exception thrown but nothing returns

Could anyone give some suggestion how can I get the LIKE operator worked in a cmis query? 

Thanks.

---

dz

Answer 1

Hi,

It is by design that LIKE operator does not work in Query service with CMIS SOAP. We currently do not support "Like", "Not Like", In", "Not In" operators.

---

Xue-mei Chang

TechNet Community Support

Answer 2

What about the query :

SELECT * FROM cmis:document WHERE CONTAINS('DesignDoc*')

Is CONTRAINS operator supported by SharePoint? It return nothing when I run the query. It was supposed to return a number of documents.

Thanks,

---

dz