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 will have to look into that. I am not sure that search results web part is available in foundation. Thank you for the idea.
I did come across another option that I think will work for my needs. I actually think I can use this a lot in the future. I created a list and library with the exact same metadata columns. Then created a Linked Data Source. Finally I used the linked data source and a Data View Web Part to display the list. I am still figuring out how to make it look nice (XSLT most likely) but the functionality I was looking for is there.
Creating a Linked Data Source in SharePoint Designer
From < http://blog.metrostarsystems.com/2013/06/14/creating-a-linked-data-source-in-sharepoint-designer/>
Step by Step add Filter to a Custom DVWP in SPD
From < http://blogs.metrostarsystems.com/2013/11/19/step-by-step-add-filter-to-a-custom-dvwp/>
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.
