This post is not meant to be an advertisment. It is more a summary of my experience with filtering lists and the lack of some possibilities with OOTB features of SharePoint. In this post i will just look at one feature which i needed for a customer.
About the scenario: In SharePoint the document library provides the functionality of using metadata navigation and metadata keyfilter webparts. This keyfilter webpart can filter the metadata column of a list /library. But the filter works only with an OR Operator on one column. That means, that one of the filter values needs to match at the column and it will display the row. Well my customer needed a solution which uses an AND Operator, so that the result will only be the items which have exactly both or all terms / filtervalues in their column.
Now you might imagine how the FilterZen webpart can help you to filter your list/library as you desire or helps you to satisfy your customers needs. I downloaded the FilterZen webpart, installed it using the setup application on the SharePoint Server and was able to add some new webparts to the page with the listview and configure my filter. The result is below in the pictures.
I also like the autocomplete input field. The configuration of the webpart is full of features, so you have many options which can be set. Learning by doing or reading the manual – what you like.
..:: I LIKE SHAREPOINT ::..