Overview:

This article explains how to configure the Data View Plus web part to aggregate content from a Hub Site and all its associated sites in SharePoint. By including the HubSiteId in the aggregation query, you can automatically include all associated sites in the scope without manually specifying each one.

Steps to Configure Aggregation Scope for Hub Sites:

1. Find Your Hub Site’s ID (HubSiteId): Every Hub Site in SharePoint has a special ID called the HubSiteId. Here’s how to find it:
2. • Go to your Hub Site in your browser.
   • Add this text to the end of the URL:/_api/site/HubSiteId
   • Example: If your Hub Site’s URL is https://example.sharepoint.com/sites/HubSite, type: https://example.sharepoint.com/sites/HubSite/_api/site/HubSiteId
   • The HubSiteId will appear as a long string of letters and numbers. Copy it for later.
3. Modify the Aggregation Query:
4. • Add this text to the query box:[your search term] AND (DepartmentId:{[hub id]} OR DepartmentId:[hub id])
   • • Replace [your search term] with what you’re looking for (e.g., “document” or “event”).
     • Replace [hub id] with the HubSiteId you copied earlier.
   • Save your changes.
5. Refresh the page and make sure you see content from the Hub Site and its connected sites.