I am working in SharePoint Foundation 2010. I have a list and a library with the exact same columns. For examples sake one of the columns is “Department”. How would I go about displaying items from the List AND the Library for Department = IT? I would like to be able to filter by any column.
Any ideas would help. I am also interested in solutions that would work in Server or Enterprise but of course would like something for Foundation.
Thank You
I am not sure if its available in foundation but you could use the search results web part and a refinement panel web part to show specific data using a query and connect it to the refinement panel.