Sometimes it is necessary to filter a list by multiple values on a certain column. In SharePoint 2013 it’s working using the UI, but in SharePoint 2010 it’s not. So in 2010 Version you could use the url query to filter a certain column using multiple values. The solution is simple and you do not have to use code or develop anything.
You can separate them by a semicolon and it acts like an OR.
The important part to add is:
?Filtername=Region&FilterMultiValue=West%20Germany;North%20Germany
so in general:
?FilterName=yourfieldname&FilterMultiValue=yourvalue1;yourvalue2
The output:
The nonplusultra Wildcard possibility:
The important part to add is:
?Filtername=Region&FilterMultiValue=*West*
so in general:
?FilterName=yourfieldname&FilterMultiValue=*yourvalue*
It’s also working with multiple values. The output:
It’s really cool, cause it also supports “*” so it’s like a wildcard filter.
Hope you like it the same way i do. Found it here.
Nice Post, In SharePoint you cannot group/Search on some columns. Please find this additional information in this Post :
http://sharepointsolutions-sudheer.blogspot.in/2014/09/cannot-group-by-or-filter-view-having.html
thanks for your comment, i appreciate that information!
Updated Link : Columns cannot group of Filter in SharePoint”