FilterZen: Feedback Forum > filtering webpart b from a column of the selected item in webpart a
Hi rip,
interesting scenario. We never added support for this, because you can do it out of the box. "Get Filter groups from" is a completely different feature, it's for the (very few) users who want to organize multiple filters of a Web Part into separate filter groups, in order to be able to switch between them.
What you want to do can be done without FilterZen. Simply connect the Accounts Web Part directly to the Contacts Web Part. This works with both single-value and multi-value Lookup Columns.
February 5, 2010 at 23:13 |
ROXORITY
ROXORITY
I have an Accounts list with relevant column Account Name (title)
I have a Contacts list with relevant column Account (lookup to Accounts list -> title)
I have a page with an Accounts web part and a Contacts web part.
I want to filter the Contacts displayed to the Account selected.
I've tried setting up a Page Column Filter and a List Lookup Filter. I don't know how to configure then correctly.
The closest I've gotten is with a List Lookup Filter but it always filters to the first item in the Accounts List, not the selected item in my web part. Here's how I did that:
1. on the Filter webpart Connections-> Get Current Filter Group From Accounts (my Accounts webpart)
2. on the Filter webpart Connections-> Send Values As Filters To Contacts (my Contacts webpart)
3. edit Filter webpart, Add new filter..., List Lookup Filter ...for Account. This sets up the filter with these values:
View URL of the lookup List: ... /Lists/Accounts/AllItems.aspx
value Column: Title
4. Uncheck Allow users to pick a filter value (because I want them to use the option button in the Accounts webpart)
5. Apply.. Okay
Now there are option buttons in the Accounts webpart. If I select the second account and look at the Filter webpart, I see:
Connected and sending values from 1 filter(s) to:
ListViewWebPart: Contacts
Order of connection events:
Value(s) sent via: Send values as filters to
Received LinkTitle: Account B (this is the second account in the Accounts webpart)
Value(s) sent via: Send values as filters to
Based on the currently avail....
One or more filter values were not sent.
Account -- reason: This filter was set to not send empty values.
6. since the "LinkTitle" was received, try setting the filter's value Column to "LinkTitle" => no change
7. Set the "default filter value" to "(The first item after pre-filtering and sorting)" =>
Connected and sending values from 1 filter(s) to:
ListViewWebPart: Contacts
Order of connection events:
Value(s) sent via: Send values as filters to
Received LinkTitle: Account B (!)
Value(s) sent via: Send values as filters to
Based on the currently avail....
Current filter values:
Account: Account A (!)
so now the filter is set to the first item in the Accounts List, but I can't get the filter to forward the "LinkTitle: Account B" to Contacts