Tuesday, June 13, 2017

FILTERING LISTVIEWS WITH URL QUERY STRING

  • Basic URL filters - AllItems.aspx?FilterFields1=ColumnName&FilterValues1=ValueText
  • Filtering multiple columns - AllItems.aspx?FilterFields1=ColumnName&FilterValues1=ValueText&FilterFields2=ColumnName&FilterValues2=ValueText
  • Multiple filter values on a single column -&FilterName=______&FilterMultiValue=____;____;_____
  • Wildcard filters - &FilterName=Product&FilterMultiValue=*jet* // for all values that contains "jet".
  • Filtering on lookup columnsAllItems.aspx?FilterFields1=Product&FilterValues1=4 // where Product is a Lookup Column and '4' is the Lookup Id of the text you want to filter.

FYI - (Interner Source) - http://sharepointificate.blogspot.de/2012/12/filtering-listviews-with-url-query.html

1 comment:

Clearing Person/Group Values

To clear out or empty the values in person or group columns, how you do it depends on if the column is single-value or multi-value. For ...