I created an external content type list that populates data from a SQL view in SharePoint Foundation 2013. The list populates the data fine and I can manually click page to page to view the data. The issue is that it is 3500+ items and I need to be able to filter the list based on a search. I can not figure out how to do this in SharePoint 2013.
Ideally I won’t be using the standard site search as it would just display links to the items. Instead having a text box that will take the users input and filter the data on the same page would be preferred. I have found that this was possible with SharePoint 2010 and SharePoint 2013 Enterprise. I have also seen third party solutions for this. Is this possible in SP2013 Foundation?
you can use REST API to filter data in script editor. your data is use must include ?$limit=3500
at the end of URL
