Wednesday, April 27, 2011

Creating external lists in SharePoint 2010 – Part 2

Here we are with part 2. If you have not gone through part 1, then I recommend you reading part 1 first before proceeding. Once you are done with reading part 1, then come back and read this part 2 to understand it bit more.

Now remove the Employees list from the SharePoint site we created earlier. Now open SharePoint Designer 2010 and open the Employees external content types.

Click on create list and form.

Then give name of the list and description. System instance will be Employees because as of now we only have one external content type in my system.

Click on Ok, it will display creating Employees list

Go back to the SharePoint site and check that list has been created. Also make a note that it shows that list is external.

If you create InfoPath form, then it appears like this


Shafaqat Ali said...


I have created the external list, i am adding records from the browsers and they are added in sql server table too but list all items page shows no records. I have refreshed the browser several time but no records found in all items page.

Shafaqat Ali said...


Just adding some more in my previous comment, i moved to list settings page and noticed there was a section for data source filters which we created at the time of creating data base operations for this external list, i removed that filter and now i am able to see all records in all items page.

Just wanted to know what was the use of that filter?

SharePoint Kings said...

shafaqat Ali,

filter is given only to filter the data based upon query. because in normal scenario its assumed that external list have thousand of item and when an external content type lacks a filter, the default behavior is to show the first 200 items and to not filter the search results.

we also got this error like "Search criteria cannot be met as Filters are not defined for the External Content Type. Contact your system administrator."

but as your question it should display at least some data. so not sure what was missing in your case. have to investigate in that area.

Thanks for sharing your thought/problems/idea with us.

Share your SharePoint Experiences with us...
As good as the SharePointKings is, we want to make it even better. One of our most valuable sources of input for our Blog Posts comes from ever enthusiastic Visitors/Readers. We welcome every Visitor/Reader to contribute their experiences with SharePoint. It may be in the form of a code stub, snippet, any tips and trick or any crazy thing you have tried with SharePoint.
Send your Articles to with your Profile Summary. We will Post them. The idea is to act as a bridge between you Readers!!!

If anyone would like to have their advertisement posted on this blog, please send us the requirement details to