Within this 12 minute video, the Lightning Conductor Web Part is configured from scratch to aggregate Task list content from multiple site collections whilst adding multiple levels of grouping and multiple columns without writing any code.
Using the built in Calendar View, content is also aggregated from multiple calendars throughout multiple web applications and displayed within a calendar.
Using a single instance of the Lightning Conductor web part, you can build multiple views of rolled-up content within the same web part. Those views can contain aggregated content from the same list type or different list types. This helps with page performance as the aggregated content is only aggregated when the view is selected and is a great alternative to having multiple instances of a roll-up web part on the same page.
The Lightning Conductor 2013 web part is a SharePoint Cross Site Collection Aggregation web part that provides Edit, Delete functionality on your aggregated SharePoint list items and opens the item in context with the page that you are on, even if the list item in question is returned from another site collection or web application. You won’t find yourself lost in SharePoint after clicking the link to open an aggregated item.
SharePoint list or library content can be rolled up and displayed on pages with conditional formatting allowing you to apply business logic and highlight content that required attention. Conditional Formatting is simple to apply and can contain multiple rules whilst applying formatting to entire rows or columns based upon a criteria being met.
|Feature||Lightning Conductor||Content by Query Web Part||Content by Search Web Part|
|Works with SharePoint Foundations 2013|
|Works with SharePoint Server Standard 2013|
|Rollup content from multiple web applications|
|Rollup content from multiple site collections|
|Rollup from selected sites or lists from different site collections or web applications|
|Rollup from single site collection|
|Rollup from specific sites in the site collection|
|Build Views without writing code or XSLT|
|Add multiple columns without XSLT or Code|
|Apply formatting without XSLT or Code|
|Easily select columns to display by selecting check boxes|
|Apply Filters without code|
|Built in Calendar view|
|Built in Posts view|
|Build views with XSLT|
|Build views with JSON|
|Display Rollup Statistics|
|Export rolled up data to Excel or CSV|
|Supports Caching for performance|
|Content loads independently of page (Ajax)|
|Rollup from multiple list types with columns in common.|
|Audience Targeting support|
|Consume Web Part Connections|
|In context viewing/editing of content|
|Works with SharePoint Foundations|
|Requires Publishing Feature|
|Edit Control Block on Title column|