04 Februari 2012 9:26
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 ?
06 Februari 2012 6:07
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:
TechNet Community Support
- Ditandai sebagai Jawaban oleh Ajay.Sawant 06 Februari 2012 7:03
06 Februari 2012 7:03Thanks for your help Pengyu