FREETEXT Predicate with wildcard

Question

Hi All,

I am using SharePoint 2007 SP2 Enterprise Edition where I would like to use the Search API to query the data from SharePoint index store with the help of FullTextSqlQuery class. I cannot use the CONTAINS predicate for this because search result ranking does not work with it [as expressed here] hence I have tried using the FREETEXT predicate in the following pattern where RANK column has shown a proper values for all the rows.

SELECT Size, Rank, Path, Title, Description, Write FROM portal..scope() WHERE FREETEXT(DefaultProperties, 'essbase') AND  ( ("SCOPE" = 'Training Search') )   ORDER BY "Rank" DESC

But then I stumbled across another issue where I found that wildcard search is not working with FREETEXT predicate. Looks like FREETEXT predicate simply does not support the wildcard search. I have tried using the above query with "essbas" and "essbas*" search phrases but no joy.. I am getting zero results..

Can someone please let me know if there is any other way of getting the wildcard search working with leveraging the RANKING capabilities of the MOSS Search ?

Thanks
Ajay Sawant

Answer 1

Hi,

 

Yes, wildcard search is possible only using Contains Predicate. There will not be relevant ranking result if we use Contains Predicate. So we cannot expect Relevant ranking in Wildcard search.

 

Please check this:

http://blogs.msdn.com/b/souravd/archive/2009/05/28/how-to-customize-the-enterprise-search-in-moss-2007.aspx

 

Thanks.

---

Pengyu Zhao

TechNet Community Support

Answer 2

Thanks for your help Pengyu