Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

We are having usual behaviour with FullTextSqlQuery and wonder if anyone can help.

The following should return 3 records which represent 3 pages on the site with titles "Sample (test1)", "Sample (test2)", and "Sample (test3)".

SELECT Title, Rank, Size, Description, Write, Path
FROM portal..scope()
WHERE ( ("SCOPE" = 'myScope') )  AND CONTAINS ('"sample"')
ORDER BY "Rank" DESC

For some reason this only yeilds 1 result, say "Sample (test3)".

If we change this to use a query as follows, then this also returns a single result. However this time the result is a different record, say "Sample (test3)", which proves more than 1 entry was indexed by the crawl.

SELECT Title, Rank, Size, Description, Write, Path
FROM portal..scope()
WHERE ( ("SCOPE" = 'myScope') )  AND FREETEXT(defaultproperties, '"sample"')
ORDER BY "Rank" DESC

Why are these queries not returning all 3 results? We have tried setting TrimDuplicates to false but it makes no difference.

share|improve this question
    
If you could move your comment about TrimDuplicates to an answer that would be great. Then we can mark this as answered :-) Thanks –  Alex Angas Jul 1 '10 at 4:41
add comment

2 Answers 2

How does the duplicate document is identified when we do a search?

Document similarity for purposes of identifying duplicates is based only on a hash of the content of the document. No File properties (e.g. file name, type, author, create and modify dates) are input to this hash. The MSSDuplicateHashes table in the SSP’s search database holds, for each document, all the 64bit hashes necessary to determine if one document is a near-duplicate of another. This is read while doing a search if duplicate collapsing is enabled.

Source: http://blogs.technet.com/b/harikumh/archive/2008/11/14/some-interesting-facts-about-sharepoint-2007-search.aspx

share|improve this answer
add comment

have you tried expanding the scope to 'All Sites'?

share|improve this answer
    
Actually it turns out that TrimDuplicates was causing the issue afterall, it wasn't deployed properly when we tested the setting the the first time around. I'm not sure why it would treat these 2 items as duplicates though, does it ignore content in braces? –  TheCodeKing Mar 26 '10 at 16:25
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.