Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Eliminatig duplicate records

  Asked By: Ali    Date: Dec 30    Category: Sharepoint    Views: 1975

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?



2 Answers Found

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

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

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.