I have created an external content type to connect to a SQL database to show client information in SharePoint 2013, once the connection was created I created a list to display all the info

I then created two filters:

Filter 1 = Is a wildcard filter to allow users to search for client names in the picker

Filter 2 = This limit the number of results in the picker

enter image description here


enter image description here

Since I created the wildcard filter all of the items in the list have disappeared

enter image description here

How do I display all the clients in the list again?

enter image description here

1 Answer 1


You should create two operations

  1. Read List - This should not have any filters applied and this should be used by the List
  2. Read Item - This should have the filters and will be used for filtering
  • Hello, I tried to edit the read item operation but it did not give me any options to apply filters Commented Nov 8, 2014 at 1:24
  • It's available in the input parameter screen, select the parameter and click the filter link on right. Commented Nov 8, 2014 at 1:43
  • Thanks, I have found that now but it does not allow me to create the wildcard filter, I added a screenshot above Commented Nov 8, 2014 at 1:51

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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