By Brett Lonsdale Aggregation Blog 2nd July 2015

SharePoint Aggregate Document Libraries

In this post, we will learn how to aggregate SharePoint Document Libraries from across multiple site collections with the Lightning Conductor Web Part.

Aggregating document libraries is useful to your business, so that you can see documents from multiple document libraries that contain certain metadata, or have a particular property set. Scenarios such as ‘All Documents that I created’, ‘Documents that I haver checked out’, ‘Documents created in the last x days’ are all very useful and can be achieved without code using the Lightning Conductor.

To rollup document libraries from multiple site collections:

From within the Lightning Conductor Web Part, click Create View.
Set a name for the view, such as All Documents Created by Me.
Select the Data Source Tab, and select your query scope. e.g. Which Site Collections, Sites or Libraries that you would like included within your query.
Set the List/Item Type to Document Library.
Click the Columns Tab to setup your view.

Now that we have defined the query as to which document libraries to include within our content rollup, we will build the view by specifying which columns to display.

Select the columns that you wish to see. For example Name, Created, CreatedBy, File Size and Version.
Set the Display Format for each column (Isn’t that easy compared to doing it in XSLT)

Create a filter to filter the results.
Click the Filter Icon next to the Modified By Column.
Set the Modified by column to equal ‘Me’.

Finally, Click the Display Tab. On the Display Tab, you will be able to configure pagination, summary functions, Grouping and Header settings.

Click the Group By Folders in order to allow folders to be expanded and collapsed.
Check the Show Document Icon
Set the linking column to Name so that users can open up documents.