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.
With the SharePoint List Filter Web Part you can easily export the results to Microsoft Excel for any further reporting needs.
You can save frequently used filters for future use, share them with others or specify them as default filters.
Filter SharePoint using variable date ranges such as [Last Year], [This Month] and [Next Week]. Refine filters and save them for future use, whether to keep private, share with others or to use as default filters.
|SharePoint Standard||List Filter Web Part|
|Column/Metadata Filter||SharePoint Search|
|Filter by column value||✔||✘||✔|
|Search now button||✘||✔||✔|
|Display number of items||✘||✔||✔|
|Complex keyword queries||✘||✔||✔|
|Search documents and attachments||✘||✔||✔|
|Connect to multiple views||✘||✘||✔|
|Save common filter||✘||✘||✔|
|Configure default filters||✘||✘||✔|
|Export to Excel||✘||✘||✔|
|Variable date ranges||✘||✘||✔|