Go 4 Sharepoint

Search:

Welcome: Guest!

Sharepoint Forum

Home » Forum » Sharepoint

Ask a question

RSS Feeds

Cannot filter on specific BDC field in the list toolbar

Asked By: Dexter Mclaughlin Date: Sep 20, 2008 Category: Sharepoint Views: 401

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.

Tagged:cannot filter on specific bdc field in the list toolbar

1 Answer Found

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

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.