likepallmatch issue for performing or operation

[Priti Barapatre]

Hi John/Mark,

I am from SupportCentral Search team. I am facing some issues when I am using likepallmatch in my code. We have set likepallmatch=1 to provide the exact match on the query terms entered. But within the same application we want to provide a new search feature which will allow user to search for different terms performing OR operation if there are more than single word. EX if I search for "marketing pricing" - it should search "marketing pricing" OR "marketing" OR "pricing". Ranking higher the results contains both the terms. I am setting likepallmatch=0 for this search feature. The issue with this is its working for few scenarios and not for other. Could you please suggest what should be the issue here?

Please let me know in case you need any other information.

Also, I am curious to know if Thunderstone provide any default ranking cutoff for the results we are displaying.(Ex. The results ranked above the default cutoff would be displayed, and lower than that would be skipped.) If yes, is there any way to change it?

Thanks & Regards,
Priti

[mark]

That should work. In what way is it not working?

There's no cutoff on the rank value. You can stop displaying at any value you like or add an OR clause to the SQL to test against $rank to limit it.

There is likeprows that will limit the total number of rows returned by a likep regardless of rank. See the docs for more details on likeprows.