SharePoint FilterField1, FilterValue1 question - how to do this?

Question

_{Wednesday, July 4, 2012 2:45 AM | 1 vote}

Hi all;

SharePoint 2010. List filter. (CanNOT use SPD or VS)

I need to filter list items from URL as: Country=USA or Country=UK.

I can filter on a single value like (Works fine)
MyURL.aspx?FilterField1=Country&FilterValue1=USA

But how to get the OR value? Following does not work (and ignores the first filter):
MyURL.aspx?FilterField1=Country&FilterValue1=USA&FilterField2=Country&FilterValue2=UK

Help is appreciated. Thanks.

All replies (9)

_{Monday, August 13, 2012 1:47 PM ✅Answered}

you can also use FilterMultiValue1 instead of FilterValue1

in your case: FilterField1=Country&FilterMultiValue1=USA;UK

_{Tuesday, November 6, 2012 7:33 AM ✅Answered | 4 votes}

found a little mistake in my anser: instead of FilterField, you need to use FilterName.

so for single values, this would be: FilterField1=Country&FilterValue1=USA

for multple values, this should be: FilterName=Country&FilterMultiValue=UK;USA

note: don't use numbers for the multi value (not FilterName1 but FilterName

_{Wednesday, July 4, 2012 2:57 AM}

Check out Laura Roger's post I think she explains how to do it. http://sharepoint911.com/blogs/laura/Lists/Posts/Post.aspx?ID=73

Benjamin Niaulin Blog: http://bniaulin.wordpress.com

Twitter: @bniaulin

_{Wednesday, July 4, 2012 3:04 AM}

Thanks Benjamin,

Above solution does not seem related to my issue. Please let me know if I am missing anything.

Your time is appreciated.

_{Tuesday, July 10, 2012 11:03 AM}

Hi ran009,

The link provied by Benjamin should be related to your issue.

If you want to use the multiple URL query string parameters with "OR" operation for a list, you need to use SharePoint Designer to configure the filter multiple parameters with "OR" operation, highlight the list view web part, add the multiple parameters and set the multiple filter criterias from the SharePoint Designer, here are some articles talking about this topic,

http://social.technet.microsoft.com/Forums/hu/sharepoint2010customization/thread/a2167e1f-dbcc-42c0-bfbf-ecb3f9010cca

http://social.technet.microsoft.com/Forums/en/sharepoint2010customization/thread/893e09a3-c742-46f1-83c9-594d6530b457 (Aviw's reply)

http://www.signaturesterling.com/blog/post/Multiple-Parameter-List-Filter-in-SharePoint-Designer-2010.aspx

Thanks

Daniel Yang

TechNet Community Support

_{Saturday, July 14, 2012 6:03 PM}

Thanks Daniel

Unfortunately I am not allowed to use SharePoint Designer nor Visual Studio. Any other ideas will be appreciated.

Thanks a lot.

_{Monday, July 16, 2012 2:33 AM}

Hi ran,

The URL query strings just pass the values, logical opeartion "Or" needs to be operated in the web part side, as far as I know OOB way could not achieve your goal, this requirement needs to use the SharePoint Designer.

Thanks

Daniel Yang

TechNet Community Support

_{Friday, March 22, 2013 3:07 PM | 1 vote}

note: i've noticed that this FilterMultiValue does not work with DocumentSets.

i've posted this in another thread:  http://social.technet.microsoft.com/Forums/en-US/sharepointgeneralprevious/thread/8aff65e0-a6f0-4aba-8411-c42c8aabc16b

_{Tuesday, January 26, 2016 1:36 PM}

Answer Wednesday, July 04, 2012 2:57 AM does not point to a working link any longer.