I have a site that contains a number of lists and libraries many of which has a field that defines what department each item is related to (e.g. image library with department logos, document library with departmental process documents, custom list showing budgets for each department for each year). I have a few web-parts I need to setup for different purposes but all essentially need to show data based on what the current users department is - for example; if someone who has "Marketing" as their department in their user profile then when navigation to a page with my desired web-parts it only shows the "Marketing" materials/data (e.g. only shows the Marketing Logo from images library, only shows Marketing process documents from document library, only shows the budgets for the Marketing department from the budget list etc...).
SO, in short, is there any way of filtering a List Views Web Part, aContent Query Web Part or a Data View Web Part with the value of the current users department?
Kind regards,
John