The SharePoint List Filter Web Part will meet your expectations and more with its outstanding convenience, usability and performance.In this article:
Saves you time with optimal performance
Get results within seconds or less, even in enormous lists or libraries with millions of items or documents. Various configuration options help you to provide your users with the best possible performance. For example you can get filter choices from definition (site users, lookup list, managed metadata tree, …) instead of querying the connected lists or you can even force users to search for a keyword before the list shows up. To sum up, it’s very flexible and can be optimized to suit your needs.
Combine search and metadata filters
Combine the power of SharePoint Server Search with the flexibility of keyword queries. This allows you to combine item, document and even attachment searches with metadata keyword searches and other metadata filters. SharePoint Search allows you to use wildcard characters and logical operators to search documents, attachments and item metadata. In addition you can select single or multiple filter values from drop-down lists or use date range pickers to filter the connected views.
In this screenshot you can see the “Course Material” document library which has already been filtered using the keyword “training”. The results can now be refined by the creation date and the author (created by).
Supports multiple lists and libraries
The SharePoint List Filter Web Part can be connected to multiple lists and libraries which allows you to search and filter more than one list or library in a single step.
Users can also select from the connected lists to limit the scope of the search.
Great user experience
With the SharePoint Filter Web Part you find exactly what you are looking for with just a few clicks thanks to comfortable and easy-to-use filter controls. You can use single or multiple value drop-downs that display the filter values to choose from or use search boxes to look for a keyword. If you include managed metadata fields, you can also display the whole managed metadata tree with all descendants.
The date range picker allows you to filter content using variable date ranges such as [Last Year], [This Month] and [Next Week]:
e.g. Year to date
and Date Range.
For keyboard users the List Filter Web Part also provides an easy and fast way to enter dates and date ranges:
e.g. Everything till today.
and Year to date.
Default filters/Common filters
You can save frequently used filters for future use, i.e. for private use, to share them with others or to use them as default filters. The following steps explain how to save a filter:
1. Define a filter
2. Save the filter as private or public
3. Define a name for the filter
4. The filter is now available
Export filtered views to Excel
With the SharePoint List Filter Web Part you can export the results to Microsoft Excel for any further reporting needs.
The SharePoint List Filter Web Part provides a print view to print all results in a clear printable format with a single click. The print view displays the whole result set, even when the size of your views are limited for performance reasons.
The SharePoint List Filter Web Part is available for SharePoint 2010, SharePoint 2013 and SharePoint 2016.