Forum Discussion
How to aggregate multiple lists into one list?
Hi Baronne!
In order to avoid redundancy items i think the easiest way to view items from all underlying risk-lists is to do the following:
One common Content Type
- Create a Common Content Type and add it to all risk-lists (in the subsites).
- Set the Content type to the default content type in all the lists in order to make sure all risk items are created based on the same Content Type.
Create a overview
In order to create an overview of the risk-items from all subsites you can choose one of this options:
- Option 1
- Create a page and add a Content Search Webpart.
- Configure the webpart so it only shows list items based on your Content type, sorting and the amount of elements you want to show.
- Option 2
- Create a page and add a Search Result Webpart.
- Configure the webpart so it only shows list items based on your Content type.
Personally I think Option 2 is the preferred solution because it will not limit the amount of list items that is displayed.
MicrosoftI use Magnus's approach all the time and it works great. Honors security trimming and easy to aggregate results. Here is a great display template to make it look like a list. https://github.com/SPCSR/DisplayTemplates/tree/master/Search%20Display%20Templates/Table%20Layout%20with%20Sorting%20Templates%20(CSWP)
The link above gave me a 404, this should work.
