?
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
Medium Priority
?
2,321 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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

These days socially coordinated efforts have turned into a critical requirement for enterprises.
A recent project that involved parsing Tableau Desktop and Server log files to extract reusable user queries for use in other systems. I chose to use PowerShell to gather the data, and SharePoint to present it...
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

741 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