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
Since I created the wildcard filter all of the items in the list have disappeared
How do I display all the clients in the list again?