aequos-solutions/modern-data-visualizer

[BUG] document data source results duplicates

Closed this issue · 8 comments

pravin080317 commented

Version used
Ex: 1.4.0

Recently we observed that document source search result items are getting duplicated in the search page. Is there a way to avoid the duplicates in the handle bar or via refinements?
Below is the query template used for the document data source. Please let us soon since this is affecting the multiple users.

Query template:
{searchTerms} -FileExtension=aspx path:https://mgt.sharepoint.com/sites/.. path:https://mgt.sharepoint.com/sites/HC path:https://mgt.sharepoint.com/sites/Tech path:https://mgt.sharepoint.com/sites/sices path:https://mgt.sharepoint.com/sites/sury path:https://mgt.sharepoint.com/sites/d ContentTypeId:0x01010075F7F92AC006D2459156407F8383D*

pravin080317 commented

We have recently setup the Geolocation. is this because of the Geolocation setup?
please note that the query builder tool gave us correct results. We have 2 geolocations set up so I'm guessing that's the issue. I
Is there a way to limit the results to the first one only and eliminate duplicates? kinldy note that this is a production issue and affecting multiple users..

Laul0 commented

Hi @pravin080317,

This is due to your GeoLocation environment as mentioned in the Microsoft documentation: https://docs.microsoft.com/en-us/microsoft-365/enterprise/configure-search-for-multi-geo?view=o365-worldwide#how-does-search-work-in-a-multi-geo-environment

We are in the case of https://docs.microsoft.com/en-us/microsoft-365/enterprise/configure-search-for-multi-geo?view=o365-worldwide#custom-search-applications

This is not a bug. The MDV results are based on SharePoint Search REST API, and in your case, the results come from all geo-locations (the request defines the EnableMultiGeoSearch property at true).

What we need to investigate, is why the results are not merged. In accordance with the documentation, it is not mentioned that the results are merged with a custom search application (https://docs.microsoft.com/en-us/microsoft-365/enterprise/configure-search-for-multi-geo?view=o365-worldwide#get-custom-search-applications-to-show-results-from-all-or-some-geo-locations)

pravin080317 commented

Thank you for pointing out to references.

Can we investigate why the results are not merged?? Do we have any alternate option/settings to overcome this issue..

Laul0 commented

We do not have any power over the OOTB merging data performed by Microsoft during a search. I don't think we were already faced with this kind of use case.

We need to investigate and plan to implement a feature to handle this use case.

That being said, if you find anything else, feel free to put this information in this thread to help us in our investigations.

In a meantime, we will check if we find any option/alternative as a workaround.

yhabersaat commented

Hi @pravin080317, @Laul0,

I've just reached out SharePoint product group at Microsoft to clarify the results merging behavior based on the documentation.

I'll update this thread when I have a feedback.

pravin080317 commented

Sure thanks

Laul0 commented

Hi,

As mentioned in the documentation, the below services work with multi-geo:

  • The SharePoint home page
  • The Search Center
  • Custom search applications that use the SharePoint Search API

It is important to understand what is mentioned in the documentation:

  • The SharePoint home page: [...] If they use the search box on the SharePoint home page, they'll get merged results from multiple geo locations.
  • The Search Center: [...] each Search Center continues to only show results from their own geo location. Admins must change the settings of each Search Center to get results from all geo locations. Afterwards, users that search in the Search Center get results from all geo locations.

    Note: the results are not merged

  • Custom search applications: Custom search applications get results from all, or some, geo locations by specifying query parameters with the request to the SharePoint Search REST API. [...]

    Note: the results are not merged

In conclusion: only the SharePoint home page merges the results returned by the search. For a custom app, we need to select the geo location(s) or get all (without the merge capability).

With these information in mind, we will add a property to the visualizer to configure the MultiGeoSearchConfiguration and specify one or several locations as explained in the documentation.

With this current state and the next release that will include this property, the only way to provide your users good results, is by creating a search page per location.

Tips/Recommandation: for a better user experience, it can be possible to create a redirection page (with a Web Part) that redirect the user to the good search page automatically based on the user profile information:

  1. User (location: US) -> search.aspx -> search-us.aspx
  2. User (location: IND) -> search.aspx -> search-ind.aspx
  3. etc.
Laul0 commented

This issue has been closed because it has been inactive for more than 30 days.
You may reopen this issue if it has been closed in error.