I am an intern at a company, so I am not completely sure about the structure of the servers etc. However, I have a library that I want to filter by the department that the currently logged on user is in. The the department that the user belongs to as well as other details should be stored on the AD.
The library is a simple document library with a few added columns that contains some meta data. Among this data is the department of the person who uploaded the specific document. Hence, for every user who opens the library, I want to show only the documents uploaded by users in his own department.
What I've tried to do was making a parameter with SharePoint Designer on the ListViewWebPart on the AllItems.aspx page and set the department of the current user in this parameter. It appears that it will then be a simple matter to filter by this parameter and the Department column in the library.
Problem is, I have no idea how to go about getting the appropriate value in the parameter. I tried making the parameter a Server Variable and using LOGON_USER and then search for the user in the 'User Profiles' list that seems to be on the system, but after hours of tinkering have made no progress.
Any help will be highly regarded.