[CMIS-767] CMIS query LIKE-predicate does not return any results from SharePoint 2013

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Not A Problem
• Affects Version/s: OpenCMIS 0.10.0
• Component/s: opencmis-client
• Labels: 2013 cmis, like-predicate paging query, sharepoint skipping,

Environment

SharePoint 2013 installation

• Assignee: Unassigned
• Reporter: Geert Zijlmans
• Created: 05/Mar/14 10:06
• Updated: 05/Mar/14 10:15
• Resolved: 05/Mar/14 10:11

Description

A CMIS query using the LIKE-predicate does not return any results when querying SharePoint 2013.

Knowing there is a document called 'Super Test.pdf'

Example CMIS query with LIKE-predicate does not return any result:
SELECT * FROM cmis:document WHERE cmis:name LIKE '%Test%'

Example CMIS query with equal-sign does return exact result:
SELECT * FROM cmis:document WHERE cmis:name = 'Super Test.pdf'

Example code:
String query = "SELECT * FROM cmis:document WHERE cmis:name LIKE '%"keyword"%'";
OperationContext operationContext = session.createOperationContext();
operationContext.setMaxItemsPerPage(maxItemsPerPage);
ItemIterable<QueryResult> qr = session.query(query, false, operationContext).skipTo(skipCount); //.getPage();
for (QueryResult hit : qr) {
String objectId = hit.getPropertyValueById(PropertyIds.OBJECT_ID);
System.out.println(objectId);
}