Go 4 Sharepoint

Search:

Welcome: Guest!

Sharepoint Forum

Home » Forum » Sharepoint

Ask a question

RSS Feeds

Eliminatig duplicate records

Asked By: Ali Vincent Date: Dec 30, 2009 Category: Sharepoint Views: 482

I use XMLHTTP object to get search results from Sharepoint
Portal server. You can see the code at the end of this e-
mail. The problem is that some of the content sources
overlap and as a result I get duplicate records. Is there
a way to command the Sharepoint to eliminate duplicate
records? For example setting something like duplicates off
or using DISTINCT like in normal SQL clause?

Tagged:eliminatig duplicate records

2 Answers Found

Answer #1 Answered By: Joey Soto Answered On: Dec 30, 2009

I don't believe there is. You can look at the UNION ALL predicate or
try a group by URL which then you can tell which results came from the
same URL.

Answer #2 Answered By: Gerard Randall Answered On: Dec 30, 2009

I am already UNION ALL predicate and also GROUP BY as well. The
problem is that there are contents sources that overlap and when user
chooses to search in both he gets double results for some records
(overlapping ones). SQL is made of number of SQL clauses joined by
UNION ALL. Do you have any suggestions to this situation?

Didn't find what you were looking for? Find more on Eliminatig duplicate records Or get search suggestion and latest updates.