Filtering a listview with multiple Values for one column

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:

Filter1

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:

Filter2

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.

The article or information provided here represents completely my own personal view & thought. It is recommended to test the content or scripts of the site in the lab, before making use in the production environment & use it completely at your own risk. The articles, scripts, suggestions or tricks published on the site are provided AS-IS with no warranties or guarantees and confers no rights.

Karsten Pohnke About Karsten Pohnke
He is Consultant for SharePoint Solutions for collaboration, communication and business processes. He provides his customers applications based on standard features as well as development or combining the power of several microsoft tools like Dynamics CRM. In his free time he tries to collect tipps and worthy experience in this blog.

3 comments on “Filtering a listview with multiple Values for one column

Submit comment

Allowed HTML tags: <a href="http://google.com">google</a> <strong>bold</strong> <em>emphasized</em> <code>code</code> <blockquote>
quote
</blockquote>

Please fill in the captcha: * Time limit is exhausted. Please reload CAPTCHA.