Symptoms

When executing GetList method and performing filtering of text column using any of SharePoint 2010 brokers in K2 4.6.6 you use filter which contain single quote it fails with the following exception:


SourceCode.SmartObjects.Client.SmartObjectException
? Message:
? Incorrect syntax near 'SOME_TEXT'.
? The identifier that starts with '%'))
 

Diagnoses

This is known issue (internal ID 442978) where SharePoint Content Service Broker: Executing the Get List method with a filter set containing a Apostrope (') fails with error.

This error occurs in 4.6.6 irrespectively of SP 2010 broker which you are using: SP Content/SP Service/SP Service V2.

This issue has been resolved in 4.6.11 and there it works - you are able to search when filter contains single quote using SP Content broker - all works without any issues.
 

Resolution

Upgrade to K2 4.6.11 to resolve this issue.