Solved

Looking for the equivilent of filtering a SharePoint list on [ME] when the peoplepicker column allows for multiple selections

Posted on 2010-11-18
3
2,265 Views
Last Modified: 2012-08-14
I've filtered peoplepicker columns in SharePoint lists using "Assigned To = [ME] " many times in the past.  I never would have guessed that if you allow the peoplepicker column to contain multiple selections and change the filter to "Assigned To contains [ME]" that SharePoint would deny your request with an informational message equivilent to "sorry, that's not allowed"

The peoplepicker field I need to filter on allows for multiple values.  It is populated from a workflow which adds users to the peoplepicker column,  seperated as usual, by a semicolon.

I could accomplish this in a dataview web part as "(Contains (Assigned To, $UserID)) works in a DVWP but this view is comprised of two two datasheets, each from a different list and I don't believe you can create a datasheet view in a DVWP when using a combined (linked) datasource.

If you have a work around as to how I can filter a view, where the peoplepicker column allows for multiple selections and the current user is included in that column.... let me know.
0
Comment
Question by:DavidWilkins
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 21

Expert Comment

by:chapmanjw
ID: 34430488
That is a limitation of vanilla SharePoint 2007.  There are two ways I have found to overcome this:  

1) Go third-party: I really like FilterZen http://roxority.com/filterzen/

2) Use some calculated column madness.  Create a calculated column that is gets its value from the people picker column.  Then filter off the calculated column.
0
 
LVL 1

Accepted Solution

by:
DavidWilkins earned 0 total points
ID: 34816163
If you allow for multiple selections in a people picker field you can still use the filter  "=" instead of using "contains"  It doesn't matter which position (in the multiple selection field) you name is in, the filter still works
0
 
LVL 1

Author Closing Comment

by:DavidWilkins
ID: 34849925
Was able to solve the issue using "=" instead of "Contains"
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

More often than not, we developers are confronted with a need: a need to make some kind of magic happen via code. Whether it is for a client, for the boss, or for our own personal projects, the need must be satisfied. Most of the time, the Framework…
This article shows how to deploy dynamic backgrounds to computers depending on the aspect ratio of display
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question