best bets

KMandalia
Posts: 301
Joined: Fri Jul 09, 2004 3:50 pm

best bets

Post by KMandalia »

We want the best bet feature to return results only when ALL words in keywords column are present in the query.

Right now best bet uses matches which is not something we can use because of the unique nature of our application. For example if we have keywords set to 'loan processing' then we want to show best bets only when the query is any of the following forms:

loan processing, processing loan, processing loans, loans processing,xyz loan abc processing, abc processing xyz loan .....................

can't uses matches (we don't want to return best bets when someone types in loan.It is too general term and it would not have any relevance to the query as such). Can't use eq (as you can see word order and proximity are not important, what is important is ALL WORDS). I am willing to repeat the description, title etc. by having only one keyword in keywords box. But we do need best bets to do something like what i mentioned above. I don't know how to accomplish this. Help is greatly appreciated.
User avatar
John
Site Admin
Posts: 2622
Joined: Mon Apr 24, 2000 3:18 pm
Location: Cleveland, OH
Contact:

best bets

Post by John »

In the query against the bestbet table use LIKEIN, and create a metamorph counter index on it.
John Turnbull
Thunderstone Software
KMandalia
Posts: 301
Joined: Fri Jul 09, 2004 3:50 pm

best bets

Post by KMandalia »

don't know how to do the second part (never done it). Could you please elaborate? Say i create index from command line then how to use the index in the query?
User avatar
mark
Site Admin
Posts: 5519
Joined: Tue Apr 25, 2000 6:56 pm

best bets

Post by mark »

KMandalia
Posts: 301
Joined: Fri Jul 09, 2004 3:50 pm

best bets

Post by KMandalia »

what would be the name of the index?
User avatar
mark
Site Admin
Posts: 5519
Joined: Tue Apr 25, 2000 6:56 pm

best bets

Post by mark »

Like any other index, you can call it whatever you want (within the naming conventions of sql indices).
KMandalia
Posts: 301
Joined: Fri Jul 09, 2004 3:50 pm

best bets

Post by KMandalia »

Pefect. One thing though... in the search settings the word forms is set to 'plural and possesives'. Using likein doesn't return results when someone has used plural/possesive of Keywords however the regular results are returned as expected..

Is this by nature of likein... what's the way around it?

Another thing I just noticed.. if I have a keyword called 'e-statement' and someone types in e-statement as query the best bets don't return any results. But if the keyword is estatement and someone types in estatement ... it works...this needs to be fixed in our case...
KMandalia
Posts: 301
Joined: Fri Jul 09, 2004 3:50 pm

best bets

Post by KMandalia »

Any idea whether the likein issues I mentioned are addressable or not...???
User avatar
John
Site Admin
Posts: 2622
Joined: Mon Apr 24, 2000 3:18 pm
Location: Cleveland, OH
Contact:

best bets

Post by John »

Currently LIKEIN always runs with suffix processing
disabled. I did try the e-statement example and it
seemed to work for me.
John Turnbull
Thunderstone Software
KMandalia
Posts: 301
Joined: Fri Jul 09, 2004 3:50 pm

best bets

Post by KMandalia »

1) When you say suffix processing disabled do you mean that e-statement=e-statement but e-statement!=e-statements? I need the suffix processing enabled, how can I do that?

2) It doesn't work for me. Can you tell me how you tried it?

Thank you.
Post Reply