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.