This article was created in response to a support issue logged with K2. The content may include typographical errors and may be revised at any time without notice This article is not considered official documentation for K2 software and is provided “as is” with no warranties.
The rule "populate list control with cache data" was configured. When using a simple filter, it works well. However, when using advanced filter, this does not work even no rules are changed.
Since you cannot specify "OR" condition without the advanced filter, this error impacts on the application.
This is caused by the difference between how the simple filter and the advanced filter are evaluated.
The simple filter is able to resolve different data types (string and int) while the advanced filter matches data types to resolve.
The cached data rule was also creating an issue, because of the topology of the SharePoint list items and how the lookups were working.
The evaluation of the filter was changed to only look at data types that matched and the functionality of the rule was changed to not use cached data.
It is also recommended to use a Smartbox SmartObject for all of the data that isn't needed on SharePoint because these calls will be much faster and reduce server load.