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



Reply via email to