SharePoint filtering list with multiple values of the same field

sharepoint, url

Solution

You'll want to use the name/value pair of `FilterName` and `FilterMultiValue` in your query string to achieve an OR filter.

For example, to filter a standard Tasks list view in a SharePoint Team Site to return all items that are "Completed" or "Deferred", your URL would look like:

http://www.example.com/Lists/MyList/AllItems.aspx?View={ViewId}&
FilterName=Status&FilterMultiValue=Completed;Deferred

In your use case, the new URL would be:

http://www.example.com/Lists/MyList/AllItems.aspx?View={ViewId}&
FilterName=Categories&FilterMultiValue=Entertainment;Health

UPDATE: Unfortunately, Microsoft does not do a great job of documenting things like query string params that work in SharePoint. I don't even remember where I first picked it up (sometimes you see a native web part doing something & try it yourself) but I've been using successfully since SP2007. Here though is a blog post from 2012 that explains the same thing & offers a few more examples: http://techtrainingnotes.blogspot.com/2012/03/sharepoint-search-filter-or-sort-lists.html

Problem

"Display the items in the list that either belongs to the category Health or Entertainment." I have a sample list: `http://www.example.com/Lists/MyList/AllItems.aspx` And if I am to filter the list items to look for Categories with the value "Entertainment", the URL will look like this: `http://www.example.com/Lists/MyList/AllItems.aspx?View={ViewId}&FilterField=Categories&FilterValue=Entertainment` Suppose I'd like to filter by the list items with the Categories "Entertainment" OR "Health". Unfortunately, this URL would not work as I can only filter with 1 value for the same field at a time: `http://www.example.com/Lists/MyList/AllItems.aspx?View={ViewId}&FilterField1=Categories&FilterValue1=Entertainment&FilterField2=Categories&FilterValue2=Health` What is the URL for filtering with multiple values of the same field ("OR" condition) in a SharePoint list?

Original source