Symptoms

For Each not working on OData source
 

Diagnoses

A test process was created to copy the data, to be scheduled nightly.

The simple process creates a reference to the OData source LIST smartobject, then does a For Each loop around the returned data and within each loop creates a local smartbox item.
When the source data is from SqlServer or other sources it works with no problem. When the source is OData, the generated item reference contains all the items in the list, instead of just the individual item expected. This has been recreated on Blackpearl as well with the ODATA broker.

It seems that the list selection has been passed to the Odata source by use of OData $filter parameters.


 

Resolution

We've applied a Coldfix on the client environment to resolve the issue