I'm using the BCS Data List to display values from the 'Contoso Inventory List' on the Microsoft SharePoint 2010 demo machine. I'm unable to allow user filtering of data - the options appear grayed out. Here's what I did:
Dropped a BCS Data List web part on my page
Selected my External Content Type Data appeared as expected I then clicked the 'Edit View' link to modify the BCS Data List view
The selections under 'Items to Retrieve' are grayed out - with "Retrieve All Items" selected by default.
I had hoped to use 'Retrieve items specified by the user' which in SharePoint 2007 BDC gave the user filtering options.I'm hoping someone can help me understand what I'm doing wrong.
ps - I get the same behavior with different SharePoint sites and External Content Types, so I don't believe it's a problem with my SharePoint site.
View Complete Post