3

We are using SharePoint 2013 On Premises and SharePoint Online (Office 365). We are using the Cloud Search Service to provide Hybrid Search functionality.

We have added SharePoint online as a result source ('HybridResults') in the On Premise Search Service Application

We are observing the following behavior:

  1. when adding a Content Search Webpart (CSWP) on a page in SharePoint Online and specifying the following query we are receiving all expected results: contentclass:STS_Web path:https://ourtenant.sharepoint.com/sites/departments

  2. when adding a CSWP on a page in SharePoint Premise and selecting the 'HybridResults' resultsource and specifying the exact same query we are receiving just 1 resultitem.

I've exported the CSWP and changed TrimDuplicates to False under DataProviderJSON

What more can I do to receive all results?

Update:

I've also tried the following queries using the API, which suggest the issue is related to TrimDuplicates:

  1. /_api/search/query?querytext='b-nl'&querytemplate='path:https://ourtenant.sharepoint.com/sites/departments contentclass:sts_web' contains 1 result:
<d:TotalRows m:type="Edm.Int32">1</d:TotalRows>
<d:TotalRowsIncludingDuplicates m:type="Edm.Int32">223</d:TotalRowsIncludingDuplicates>
  1. /_api/search/query?querytext='b-nl'&querytemplate='path:https://ourtenant.sharepoint.com/sites/departments contentclass:sts_web'&trimduplicates=false contains all results:
<d:TotalRows m:type="Edm.Int32">223</d:TotalRows>
<d:TotalRowsIncludingDuplicates m:type="Edm.Int32">223</d:TotalRowsIncludingDuplicates>
Improve this question
6
  • Are you certain the problem is duplicates? It could be that the On-Prem identity is not being correctly recognized by Office 365. Do you have the prerequisite User Synchronization and User Profile Service configured?
    – Matthew McDermott
    Oct 6, 2016 at 20:22
  • I'm pretty sure: I can find every single site that I want by changing my query, I just can't receive more than one result at a time. It's not like some results are inaccessible, they are just missing from certain query's.
    – Robert Wagenaar
    Oct 6, 2016 at 21:05
  • and, yes, Active Directory synchronization with Azure Active Directory is configured and working fine
    – Robert Wagenaar
    Oct 6, 2016 at 21:07
  • Did you find any solution? I gues this is still a problem. SharePoint 2016 OnPRemise is still just returning the trimmed results from O365. This article talks about the same problem. summit7systems.com/…
    – Sebastian Schütze
    Nov 3, 2016 at 10:20
  • unfortunately not, we decided to work around it by redirecting users to equivalent pages in SharePoint Online that work as expected
    – Robert Wagenaar
    Nov 3, 2016 at 16:27

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.