[ic] Swish search with wildcard

Music music at labyrinth.net.au
Sun Dec 6 07:31:54 UTC 2009


Swish-e doesn't index partial words. Fuzzy searching improves results but 
with words like part numbers wildcards are needed.

i.e. if a product description is VTR200c
searching for VTR200 will not find the product, even when using Swish from 
the command line:

swish-e -w VTR200 -f swish-e.db
will find zero results.

swish-e -w VTR200* -f swish-e.db
will find the product.

The same thing occurs when using an IC search form. The item is only found 
if the customer is smart enough to enter a * after the search term in the 
form which is highly unlikely for most visitors.

I have tried several different fuzzy index methods in swish and also setting 
mv_substring_match to true however cannot find products like these using IC 
and Swish-e.

<form action="[area search]" method=post>
<INPUT TYPE=hidden NAME=mv_substring_match VALUE=1>
<INPUT TYPE=hidden NAME=mv_searchtype VALUE=swish>
<INPUT TYPE=hidden NAME=mv_matchlimit VALUE=10000>
<INPUT TYPE=hidden NAME=mv_min_string VALUE=3>
<INPUT TYPE=hidden NAME=mv_search_page VALUE="results_swish">
<INPUT TYPE=hidden NAME=mv_session_id VALUE="[data session id]">
<INPUT MAXLENGTH=40 NAME=mv_searchspec type=text>
</form>

So to the question, is there a way of appending the wildcard * to the 
mv_searchspec in a form or some other way to use mv_searchspec with a wild 
card search invisible to the end user?

Should mv_substring_match actual work in this instance or is there another 
search parameter that I am missing?








More information about the interchange-users mailing list