SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am testing SharePoint 2010 foundation with bcs to access one of my sql tables. I created a list with filters on some fields (wildcard and limit types)

But unfortunately, when I display (browser) the list no selection fields appear Do you know why? Is it because of I'm using foundation?

share|improve this question
what do you mean, "selection fields"? – Derek Gusoff Jun 17 '12 at 3:09

You need to set default values on your wildcard filters. When you set up filters on a BCS Read List operation, the list will show whatever the default value of the filters allow.

Do do this, when you are setting up the filter, you'll see a text box for "Default Value". Enter a value in there and update the ECT, and you should be all set.

share|improve this answer

are you getting any error messages? here is a post with some BCS related errors & fixes -

share|improve this answer

BCS works flawlessly on SharePoint foundation. I have imported an SQL Azure table as a external list and tested it for basic CRUD operations. Can you give more details about your error?

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.