How to aggregate multiple lists into one list?

[Deleted]

How would you go about creating a centralised company-wide "risk register" list that aggregates list items (pulls or pushes?) from multiple "risk registers" in various business departments (in other subsites in same site collection)?  

[#2]

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.

[#3]

I 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%20...

[#4]

thanks for this, I'll give it a whirl and see how it goes

[#5]

The link above gave me a 404, this should work.

[#6]

Hi,
I‘m late to the party but you might want to try the List Aggregator Add-In:
https://appsource.microsoft.com/de-de/product/office/WA104380549?tab=Overview