| Feature | FilterZen for SharePoint | SharePoint without FilterZen |
| Text Filters | WSS & MOSS |
MOSS Enterprise Edition only |
| Choice Filters | WSS & MOSS |
MOSS Enterprise Edition only |
| Date Filters | WSS & MOSS |
MOSS Enterprise Edition only |
| List Lookup Filters | 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 Enterprise Edition only |
| Page Column Filters | WSS & MOSS Optionally strip internal ID;# prefixes. |
MOSS Enterprise Edition only |
| Page URL / Request Filters | WSS & MOSS: URL query string parameters, URL path fragments, posted form data values, server-side variables |
MOSS Enterprise Edition: URL query string parameters only |
| User Filters | 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 Enterprise Edition: current user only |
| SQL Data Filters | 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 Enterprise Edition: SQL Server 2005 Analysis Services cubes only |
| Binary Toggle (Yes/No Check Box) Filters | 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 | WSS & MOSS |
No |
| Select and send multiple values per filter | WSS & MOSS with full support for all filter types |
MOSS: 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 | WSS & MOSS |
No |
| Create with one click the right filter, optimally pre-configured for the selected filterable column of the connected List View | WSS & MOSS |
No |
| Override most Web Part and Filter settings with URL parameters | WSS & MOSS |
No |
Remember last filter value used for each user | WSS & MOSS |
No |
| Interactive filter controls caption label and CSS styles customizable | WSS & MOSS: fully supported and documented |
MOSS Enterprise Edition: only limited support, not documented |
| Built-in, high-resolution filter diagnostics and debug output | WSS & MOSS |
No |
| Filter name (internal Column name) finder tool | WSS & MOSS: all Filter types |
No |
| Enable and disable filters easily | WSS & MOSS: all Filter types |
No |
| Complete control over Empty, All and Default filter value | WSS & MOSS: all Filter types |
MOSS: Enterprise Edition only |
| Fallback filter value to replace Empty filter value | WSS & MOSS: all Filter types |
No |
| Filter value black-listing or white-listing | WSS & MOSS: all Filter types |
No |
| Pre-filter pickable choices according to List data | 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) | WSS & MOSS: Choice, List Lookup, SQL Data, User and BDC Filters |
No |
