Sharepoint Forum

 
Home » Forum » Sharepoint       Ask a questionRSS Feeds

Reg SPPS Web DAV Queries

  Asked By: Meera Oza         Date: Dec 21, 2009      Category: Sharepoint      Views: 194
 

in web dav queries there are two predicates for
full text search,
1. CONTAINS predicate
2. FREETEXT predicate.

Can any one of you tell me which one is used for
what purpose.

I have read the SPPS documentation and found that
CONTAINS can be used for exact matches and FREETEXT searches in all the columns.
But i need to know which
one is better or more optimized.

Tagged:          

 

2 Answers Found

 
Answer #1       Answered By: Latrice Henson          Answered On: Dec 21, 2009       

Depends what you want to do. The default query for the search web  part
primarily uses freetext. This will give you a broader result set.
Freetext will use stemming and thesaurus. If you search  for run, it will
look for run, ran running ect and any words in the thesaurus that
matches these. If you use a phrase as a search term freetext will look
for each individual word as well as any combos of the words in the
phrase. I believe where freetext looks (in all col) depends on where
you tell it to look, it does not have to be all cols. Contains is a more
exacting It will not stem or use thesaurus. It will not look for
combinations of the words in phrases.

Generally use freetext if you want to get a larger (less specific )
resultset. Use contains if you want to exactly match.

 
Answer #2       Answered By: Nidhi Tiwary          Answered On: Dec 21, 2009       

msdn.microsoft.com/.../_fr\
eetext_predicate.asp
msdn.microsoft.com/.../_co\
ntains_predicate.asp

The CONTAINS predicate is better suited for "exact matches,"
in contrast to the FREETEXT predicate, which is better suited
to finding documents containing combinations of the search
words spread throughout the column.

 
Didn't find what you were looking for? Find more on Reg SPPS Web DAV Queries Or get search suggestion and latest updates.


Your Answer
  • Answer should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].