Applies to the List Filter Web Part for SharePoint on-premises
How to: Filtering external lists using the List Filter Web Part in SharePoint 2013
When using the List Filter Web Part to filter an external list your search will simply return the original list and is not filtered.
It is possible, however, to configure the List View Web Part to correct this problem.
To do this you need to edit the list List View Web Part settings. Click on Edit page.
Then Edit web part.
The select the Server Render option.
Then confirm the changes and you will be able to filter the list as normal.
