SharePoint 2010 Create View based off Department

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!
brendan-amexAsked:
Who is Participating?
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
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
 
brendan-amexAuthor Commented:
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
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.