Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Cannot filter on specific BDC field in the list toolbar

  Asked By: Dexter    Date: Sep 20    Category: Sharepoint    Views: 1793

A list is displaying secondary BDC field of both string and decimal types. For some reason the string types do not allow filtering on the field from the list toolbar dropdown, the decimal types do allow filtering. Strangely enough, another library in the same site collection (so with the same BDC definition) does allow filtering on some string type BDC fields, but not on all fields.

I also noticed that the fields / columns that do not allow in place filtering are also not available in a calculated column.



1 Answer Found

Answer #1    Answered By: Rebecca Lewis     Answered On: Sep 20

Microsoft has now confirmed that this change was by design. They changed the secondary  BDC text columns  from a single line to multiple lines, which cannot be sorted or filtered. The fix was put in to address complaints from some users that data was being truncated.

They also told us that there is no known workaround, including trying to use SharePoint Designer to change the settings. However, I think it would be worth investigating if this can be changed back using the CAML definition  files (not sure where these BDC settings are defined though).

They have also warned us that changes to BDC field  settings in existing lists (where the filtering/sorting still works) may actually break the functionality as well (!).

It seems this change wasn't really thought through very well; hopefully more people will report this as an issue so they can provide a workaround/solution.

Didn't find what you were looking for? Find more on Cannot filter on specific BDC field in the list toolbar Or get search suggestion and latest updates.