Weighted Search Results / Multi-Value Value's Not Aggregating Weight

[David Radunz <da...@boxen.net>]

Hey,

     I have been having some problems getting good search results when 
using weighting against many fields with multi-values. After quite a bit 
of testing it seems to me that the problem is (at least as far as my 
query is concerned) is that the only one weighting is taken into account 
per field. For example, in a multi-value field if we have "Comedy" and 
"Romance" and have separate weightings for those - the one with the 
highest weighting is used (and not a combined weighting). Which means 
that searched for romantic comedy returns "Alvin and the Chipmunks" 
(Family, Children Comedy).

Query:

facet=on&fl=id,name,matching_genres,score,url_path,url_key,price,special_price,small_image,thumbnail,sku,stock_qty,release_date&sort=score+desc,retail_rating+desc,release_date+desc&start=&q=**+-sku:"1019660"+-movie_id:"1805"+-movie_id:"1806"+(series_names_attr_opt_id:"454282"^9000+OR+cat_id:"22"^90000+OR+cat_id:"248"^90000+OR+cat_id:"249"^90000+OR+matching_genres:"Comedy"^90000+OR+matching_genres:"Romance"^70000+OR+matching_genres:"Drama"^50000)&fq=store_id:"1"+AND+avail_status_attr_opt_id:"available"+AND+(format_attr_opt_id:"372619")&rows=4

     Now if I change matching_genres:"Romance"^70000 to 
matching_genres:"Romance"^700000 (adding a 0) suddenly the first result 
is "Sex and the City: The Movie / Sex and the City 2" (which ironically 
is "Drama", "Comedy", "Romance - The very combination we are looking for).

     So is there a way to structure my query so that all of the 
multi-value values are treated individually? Aggregating the 
weighting/score?

Thanks in advance!

David

Re: Weighted Search Results / Multi-Value Value's Not Aggregating Weight

[David Radunz <da...@boxen.net>]

Hey,

     Please disregard this, I worked out what the actual problem was. I 
am going to post another query with something else I discovered.

Thanks :)

David

On 22/08/2012 7:24 PM, David Radunz wrote:
> Hey,
>
>     I have been having some problems getting good search results when 
> using weighting against many fields with multi-values. After quite a 
> bit of testing it seems to me that the problem is (at least as far as 
> my query is concerned) is that the only one weighting is taken into 
> account per field. For example, in a multi-value field if we have 
> "Comedy" and "Romance" and have separate weightings for those - the 
> one with the highest weighting is used (and not a combined weighting). 
> Which means that searched for romantic comedy returns "Alvin and the 
> Chipmunks" (Family, Children Comedy).
>
> Query:
>
> facet=on&fl=id,name,matching_genres,score,url_path,url_key,price,special_price,small_image,thumbnail,sku,stock_qty,release_date&sort=score+desc,retail_rating+desc,release_date+desc&start=&q=**+-sku:"1019660"+-movie_id:"1805"+-movie_id:"1806"+(series_names_attr_opt_id:"454282"^9000+OR+cat_id:"22"^90000+OR+cat_id:"248"^90000+OR+cat_id:"249"^90000+OR+matching_genres:"Comedy"^90000+OR+matching_genres:"Romance"^70000+OR+matching_genres:"Drama"^50000)&fq=store_id:"1"+AND+avail_status_attr_opt_id:"available"+AND+(format_attr_opt_id:"372619")&rows=4 
>
>
>     Now if I change matching_genres:"Romance"^70000 to 
> matching_genres:"Romance"^700000 (adding a 0) suddenly the first 
> result is "Sex and the City: The Movie / Sex and the City 2" (which 
> ironically is "Drama", "Comedy", "Romance - The very combination we 
> are looking for).
>
>     So is there a way to structure my query so that all of the 
> multi-value values are treated individually? Aggregating the 
> weighting/score?
>
> Thanks in advance!
>
> David
>
>