I have a BDC entity whose fields contain a variety of data – numbers, dates and strings.
When I use the business data list web part I find that some of the columns’ dynamic filtering (accessed from the list’s column header) doesn’t work.
For these problem fields, the filter values load correctly but when I select a value all records disappear.
Initially I thought this was limited to just string columns but there is one string column that does filter correctly.
Here are some things that may be useful to know:
The datasource is a SQL view and all fields are varchar(255)
View Complete Post