Feature | FilterZen for SharePoint | SharePoint without FilterZen |
Text Filters | SharePoint 2013 & 2010, Foundation & Server WSS & MOSS |
MOSS/Server Enterprise Edition only |
Choice Filters | SharePoint 2013 & 2010, Foundation & Server WSS & MOSS |
MOSS/Server Enterprise Edition only |
Date Filters | SharePoint 2013 & 2010, Foundation & Server WSS & MOSS |
MOSS/Server Enterprise Edition only |
List Lookup Filters | SharePoint 2013 & 2010, Foundation & Server WSS & MOSS Specify absolute, site collection-relative or web site-relative initial View URL, optionally remove duplicate values or titles, optionally specify CAML for pre-filtering and pre-sorting, optionally sort CAML-less by display column, display frequency, value column or value frequency (all ascending or descending), optionally strip internal ID;# prefixes. |
MOSS/Server Enterprise Edition only |
Page Column Filters | SharePoint 2013 & 2010, Foundation & Server, WSS & MOSS Optionally strip internal ID;# prefixes. |
MOSS/Server Enterprise Edition only |
Page URL / Request Filters | SharePoint 2013 & 2010, Foundation & Server, WSS & MOSS: URL query string parameters, URL path fragments, posted form data values, server-side variables |
MOSS/Server Enterprise Edition: URL query string parameters only |
User Filters | SharePoint 2013 & 2010, Foundation & Server WSS & MOSS Optionally specify CAML for pre-filtering and pre-sorting, optionally sort CAML-less by display column, display frequency, value column or value frequency (all ascending or descending), optionally strip internal ID;# prefixes. |
MOSS/Server Enterprise Edition: current user only |
SQL Data Filters | SharePoint 2013 & 2010, Foundation & Server WSS & MOSS Any ADO.NET-compatible data source, including SQL Server 2000 or higher, Oracle 8.1 or higher, Access 2000 or higher, any ODBC or OLEDB database, full support for custom or third-party ADO.NET data source providers |
MOSS/Server Enterprise Edition: SQL Server 2005 Analysis Services cubes only |
Binary Toggle (Yes/No Check Box) Filters | SharePoint 2013 & 2010, Foundation & Server WSS & MOSS |
No |
BDC Filters | MOSS Enterprise Edition |
MOSS Enterprise Edition |
Business Data Item Builder Web Part | Fetches instance ID from any connected Web Part, or from Text Filters, Choice Filters, List Lookup Filters, Page Column Filters, Page Request Filters, User Filters, SQL Data Filters, or BDC Filters; sends entity instance or individual column values to BDC Web Parts or any other consumer Web Parts. |
Fetches instance ID only from URL query string parameter value, sends entity instance only to BDC Web Parts. |
Send multiple filters from one Filter Web Part | SharePoint 2013 & 2010, Foundation & Server WSS & MOSS |
No |
Select and send multiple values per filter | SharePoint 2013 & 2010, Foundation & Server WSS & MOSS with full support for all filter types |
MOSS/Server: Enterprise Edition only (partially) |
Dynamically generate on-the-fly all interactive filter controls, optimally pre-configured for all filterable Columns of the connected List View | SharePoint 2013 & 2010, Foundation & Server WSS & MOSS |
No |
Create with one click the right filter, optimally pre-configured for the selected filterable column of the connected List View | SharePoint 2013 & 2010, Foundation & Server WSS & MOSS |
No |
Override most Web Part and Filter settings with URL parameters | SharePoint 2013 & 2010, Foundation & Server WSS & MOSS |
No |
Remember last filter value used for each user | SharePoint 2013 & 2010, Foundation & Server WSS & MOSS |
No |
Interactive filter controls caption label and CSS styles customizable | SharePoint 2013 & 2010, Foundation & Server WSS & MOSS: fully supported and documented |
MOSS/Server Enterprise Edition: only limited support, not documented |
Built-in, high-resolution filter diagnostics and debug output | SharePoint 2013 & 2010, Foundation & Server WSS & MOSS |
No |
Filter name (internal Column name) finder tool | SharePoint 2013 & 2010, Foundation & Server WSS & MOSS: all Filter types |
No |
Enable and disable filters easily | SharePoint 2013 & 2010, Foundation & Server WSS & MOSS: all Filter types |
No |
Complete control over Empty, All and Default filter value | SharePoint 2013 & 2010, Foundation & Server WSS & MOSS: all Filter types |
MOSS/Server: Enterprise Edition only |
Fallback filter value to replace Empty filter value | SharePoint 2013 & 2010, Foundation & Server WSS & MOSS: all Filter types |
No |
Filter value black-listing or white-listing | SharePoint 2013 & 2010, Foundation & Server WSS & MOSS: all Filter types |
No |
Pre-filter pickable choices according to List data | SharePoint 2013 & 2010, Foundation & Server WSS & MOSS: Choice, List Lookup, SQL Data, User and BDC Filters |
No |
Cascading drop-down and multi-selection filters (ie. pickable choices in filter B are limited depending on user-picked choices for filter A) | SharePoint 2013 & 2010, Foundation & Server WSS & MOSS: Choice, List Lookup, SQL Data, User and BDC Filters |
No |