FilterZen: Feedback Forum > Is the column to be filtered need to be shown on the filtered web part?
Hi Cedric,
this is certainly supported!
In the FilterZen Web Part settings tool-pane, check the CAML filtering mode option (down under 'Advanced Filtering Settings') and the Cascading pre-filtering option (in the 'Interactive Filters' section that becomes available once you have at least one interactive filter added to your Web Part).
For both of your List Lookup Filters, enable at least 'Allow users to pick a filter value', and 'Allow selection of multiple values' if required.
If you get stuck, just let us know, we should be able to help you get started quickly.
ROXORITY
So the short answer is yes, you don't need to have the columns displayed to filter by them.
ROXORITY
Great news! I'll try your web part on Monday and will let you know. Thank you very much. Your web part seems to be fantastic :o)
Cedric Oster
Could you please help me to configure the web part to filter by a column which is not show on the filtered web part?
I want to use a choice filter but if when the column is not present in the web part I want to filter then your filter web part does not offer me the possibility to choose it. I can send you screenshots if you provide me with an email address.
Thank you in advance for your help.
Cedric Oster
Hi Cedric,
this is not a problem, just needs some getting used to. Here's the issue: you need to enter your filter name yourself --- FilterZen cannot *offer* you the hidden Column filter because it doesn't *know* about the Column when it's not being displayed. But you can still use it! Just create a new Choice filter and give it the same name as your Column. It is crucial that you do not use the Column's display name but its internal name.
If you can't make it work, just get back to us, but it's supported and works.
ROXORITY
When I manually enter the column name the "Specify the valid choices, one per line." are empty! Is that normal? Do I have to manually enter the values? I'd like the values to be populated from the list values.
Cedric Oster
There's a special filter type for what you want, and that's the "List Lookup Filter".
Now that's pretty tricky to configure manually, so I suggest you do this:
- add a normal List View with your Choice Column being visible
- connect to it
- create a List Lookup Filter (not a Choice Filter) for that Choice Column by using the suggested template from FilterZen
- now you can disconnect from and remove your temporary List View Web Part again
- your List Lookup Filter will stay intact.
ROXORITY
I need to filter a list of items with 2 categories (both multi choice). From reading the features it sounds like your web part pre filters pickable choices (Category B filter will only show choices according to category A). Great!
I need to show the filtered items in the list based on the Category A and Category B but I don't want to show the Category A and Category B in the filtered web part. Is this feasible?
Thank you in advance for your help.