Friday, November 22, 2013

Filtering ListViews with URL Query String

I have used this technique for filtering Sharepoint 2013 Map view

Url?&FilterField1=<LIST COLUMN NAME>&FilterValue1=<COLUMN VALUE TO FILTER>

Filtering Multiple Columns

Filters on additional columns can be appended with

&FilterField2=_____&FilterValue2=_____

And so on.

Multi-value Filters

To apply multiple filter values to a single column, the syntax is a little different:

&FilterName=______&FilterMultiValue=____;____;_____

Separate each filter value with a semi-colon ( ; ). 

Wildcard Filters

FilterMultiValue also supports partial matches.  Use the asterisk ( * ) symbol to indicate a wild card. For instance,

&FilterName=Product&FilterMultiValue=*jet*

shows all orders whose Product contains the string "jet":


No comments:

Post a Comment