New answers tagged

0

I was facing the same problem these days and found the solution in my case ! I'm posting this hoping that it would help. Context: Sharepoint 2013 Online. External data in SQLSERVER 2012. Scenario: via SPD, I've created an external content type, choosing SQL server for the data source. I've created an external list from this ECT. Problem: In my site, ...


0

You seem to be running into the 2000 item limit for BCS, which you could increase but may still not be able to resolve your issue completely. First Option Here is a similar question: BCS External Content Type with 20,000+ items (O365) The accepted answer says: I had a similar issue this morning, with an external dataset with around 100,000 records. ...


0

If somehow database goes offline, or gets deleted, you will not access external list anymore. Because data does not reside in SharePoint and it is not SharePoint’s responsibility on how the data behaves. SharePoint is here to just present the external data. Checkout some limitations of the External List: ...


1

I've been working on this task from many days. My limitations was to only use SharePoint Designer. I couldn't use visual studio or other custom code. After digging into google for many days, I've done this by performing following steps: Add one Business Data List Web part on the page. Configure that web part by choosing your External content type in Edit ...


0

If you have less than 2000 (default threshold value to throttle records from a database backed BCS model) items, you can use CAML query as you would query a normal list. It would work the same. But as soon as you have items more than 2000, CAML query will not return results. I searched, researched and leveraged resources available to me and came up with ...


0

You can add Query string URL Filter webpart from Filter above BDC list and connect it with BDC list.



Top 50 recent answers are included