Disable or increase the truncation of External Data

Question

Check this post: http://social.technet.microsoft.com/Forums/en-US/sharepoint2010customization/thread/e8de78d1-79c6-4f89-ab54-5d3b9fb96d0c#003e7056-996a-412e-a5c2-c020d0f12a65

Is there really no way to disable or increase the truncation of External Data?

---

Follow me @SPVandeput

Answer 1

Hi,

If you are asking about BCS Picker then it definitely will show up to 200 items (this is SharePoint restriction). This value can't be increased. You should always define filters (it can be limit/comparison/wildcard filter) so that you can narrow your search and overcome others restrictions regarding a count of rows in the database. Especially when working with high volume of items, there might be cases in which you may have millions of items to pick.

Please take a look at these articles about filter creation:

• Creating Comparison and Wildcard Filters for BCS in SharePoint Designer 2010
• How to: Define Filters for External Item Picker Controls

If you are asking about External List throttle (2000 items) then it can be increased.

• The default Max is 2,000 items
• The absolute Max is 25,000 items

Take a look at this article: Understanding BCS Architecture

---

Dmitry

Lightning Tools Check out our SharePoint tools and web parts | Lightning Tools Blog