I am currently configuring an AI Search index source on the m2m_connected_content table (long story!). There are some instances where there is more than 1 record for the same piece of content (e.g. a Software application that is associated with more than 2 topics is shown twice).
Is there any way to only show unique results and filter out these duplicates, a bit like you would do a GROUP BY in a list view. I can't see a way of grouping in this way from the index source filter, but maybe there is another way to only show unique results in the search application configuration(?)
Thanks in advance,
Rich
