Filtering in Business Connectivity Services from WCF Service

I have found few excellent article to define BCS Filter coming from SQL Database as per below.

But I can not find “Filter Parameter” in second step of BCS Read List operation. Also, I have difficulties to find good article on how to add filtering in BCS from WCF Service. Hence, I posted this article.

There are couple of great articles to build WCF Service that can be consumed by BCS below. It is a good starting point:


Probably some of you have the same problem or familiar with below error messages:

No Filter to select in Find drop down box.

BCS1Could not find item that is exists.



Could not validate item that is exists.




1. Update your WCF Service to retrieve all records service contract to accept filter parameter (in my scenario ActiveOnly and NameFilter)

2. In SharePoint Designer > Remove existing Read List operation

3. In SharePoint Designer > Create new Read List operation from updated WCF service contract

4. Read List operation step 1, enter Operation Name and Display Name and click Next


5. Read List operation step 2, set ActiveOnly default value to true and configure filter to NameFilter parameter, then click Next


6. Read List operation step 3, set Id as Map to Identifier and show AffiliateName in picker, then click Finish


7. Create new list from External Content Type & Ensure the list retrieving records


8. Create / Update your list to add / update External data column to new External Content Type list

9. Ensure it has “Name” in filter drop down box and could validate existing item works





Tagged: , , , , , , , , , , ,

4 thoughts on “Filtering in Business Connectivity Services from WCF Service

  1. Sebastian Fernandez 08/29/2014 at 1:50 PM Reply

    how do i do for have more than one filter. for examploe: “Name”…”LastName…etc

    • tjenho 08/29/2014 at 10:07 PM Reply

      Your wcf service needs to accept multiple filter parameters. Then you just add new filter in bcs configuration. So the drop down box will have name and last name? But you only filter based on one field. Either by name or last name.

  2. contentmgmnt 09/18/2017 at 2:08 PM Reply

    Thank you for such a nice post… I am getting same issue for filter parameters with BCS WCF.

    Would you please let me know what and where to write code in WCF BCS code to accept more filter parameters(step 1 which you have mentioned in code) ? That would help me a lot…

    Diana Shah

    • tjenho 09/18/2017 at 4:03 PM Reply

      That is your WCF service code where you implement your service.

Leave a Reply

Please log in using one of these methods to post your comment: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: