?
Solved

SharePoint 2010 Create View based off Department

Posted on 2013-01-04
3
Medium Priority
?
796 Views
Last Modified: 2013-01-04
I'm trying to create a view based off of a users department in ADUC.

I created a view that shows everything a user has modified by saying when Modified is equal to [Me]. I have a Department field that corresponds with a users "Department" in ADUC. How do I pull that ADUC attribute into the view? I would imagine something like [Me].[Department]. Anyone have a clue?

Thanks!
0
Comment
Question by:brendan-amex
[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 50

Accepted Solution

by:
Ingeborg Hawighorst (Microsoft MVP / EE MVE) earned 2000 total points
ID: 38745540
Hello,

you can't do that with a SharePoint view out of the box. This would required custom code.

If you want to stick to out of the box functionality, you could add a column for "Department" to the list, populate it with the values per user (this could be done with a workflow when the document is created) and then create a view that is filtered on the Department column.

You can then connect the List view web part with a Filter web part,  so that if a filter is selected in the Filter web part, the view is filtered by that parameter.

That way, you only need to build one view, instead of hard-coding a department filter and building a view for each department.

cheers, teylyn
0
 

Author Comment

by:brendan-amex
ID: 38745577
Thanks Teylyn, I'm not sure I follow what you say though. I want the view to update based on the person hitting the webpage, which would mean I would have to affix the Department name to the individual person in SharePoint, correct? There is already a Department column on my list.
0
 
LVL 50
ID: 38745587
What I'm saying above is: It can't be done. At least not with out of the box tools.

You would need code for that.

As an alternative, you can create views by department.

I'm not in front of SharePoint right now, but it might be possible to use SharePoint Designer and a DVWP to create a filter parameter on the current user's department, especially if that is stored in a field in the list.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

A procedure for exporting installed hotfix details of remote computers using powershell
After seeing many questions for JRNL_WRAP_ERROR for replication failure, I thought it would be useful to write this article.
This tutorial will walk an individual through locating and launching the BEUtility application and how to execute it on the appropriate database. Log onto the server running the Backup Exec database. In a larger environment, this would generally be …
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…
Suggested Courses

764 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