SharePoint 2013 Foundation (SPF) and Server (SPS) SharePoint 2010 Foundation (SPF) and Server (SPS) Windows SharePoint Services (WSS) 3.0 / Microsoft Office SharePoint Server (MOSS) 2007
SPF & SPS 2013 • 2010 • 2007
User Voices

FilterZen: Feedback Forum > 2-3 Stage User Profile Property Filter

I want to display all the badge number in a list for a managers department.
I have a list with a column "BadgeNo". The custom user profile property "Badge" contains the badge number of every user. All users belong to a department. The user profile property "Department" is used for this. Some users are obviously managers. The user profile property "Title" is used for the manager title e.g. "Manager Mechanics".
The list may only be shown to managers. So, first I need to filter all managers based on the "Title" property. Then the "Department" user profile property of the current (logged in) manager should be sent to a 2nd filter. Finaly, this filter should sent the all the "Badge" user profile properties (of the managers department) to the list.
Is this the way to do it, do I need different approach or is it not possible with FilterZen?
Thank you for your time


December 20, 2011 at 0:44 | Unregistered CommenterPeter

Sounds reasonable. Use Text Filters for all filters unless you have a different UI need for a specific filter. Ie. the Title filter would be a "hidden" (ie. un-ticked "allow users to enter a filter value" check-box option) Text Filter defaulting to the filter value Manager, possibly using the filter operator "Contains" rather than Equal to capture values such as "Manager Mechanics" (which will require you to enable the CAML Direct Filter Mode for this FilterZen Web Part).

Why are you using a List rather than a User Profiles Web Part such as PeopleZen? How is that List being synced with your user profiles data base?

December 20, 2011 at 17:50 | Registered CommenterROXORITY

Thank you for the reply.
The reason why I am using a list is because the list is a BDC of a SQL Table (View) with multiple "BadgeNo" rows. The link between the two is the badge number. So, there is no sync.

December 20, 2011 at 21:00 | Unregistered CommenterPeter

Can you tell me how to select a custom user profile property in a text filter? I can select the property "Title", but I can't select "Badge". In PeopleZen this is no problem.

December 22, 2011 at 0:59 | Unregistered CommenterPeter

You can use for your filter name *any* name that exists in the connected List, whether you can select it or not. Though if this is a Column in the connected List you should be able to select it. One way or the other, FilterZen doesn't (yet) know about "user profile properties", only your List Columns.

December 23, 2011 at 3:27 | Registered CommenterROXORITY

Then I'll have a problem because the "Department" and the "Title" property isn't a column in the connected List. I want to make a filter using "user profile properties" of the current user.

January 4, 2012 at 23:25 | Unregistered CommenterPeter

OK, got it. That functionality is coming up real soon but in the current FilterZen version, it's not there yet.

January 5, 2012 at 8:39 | Registered CommenterROXORITY