Taminidi,
Relevance ranking is tricky and very domain specific. There are usually multiple ways to do the same thing, each is better at some edge cases and worse at some others :)
It looks to me that you are trying to rank the products by: exact match on SKU, then exact match on ManufactureSKU, then text match on SKU, …, then finally text match on names and description.
One way of doing this is you index your products to fields like exact_sku, text_sku, etc. with the proper text analysis chains. You can then use edismax query, and assign the right weights to these fields, e.g.:
exact_sku^10 text_sku^9 …
Regards,
Tri
On Feb 14, 2014, at 10:11 AM, "EXTERNAL Taminidi Ravi (ETI, Automotive-Service-Solutions)" <external.ravi.tamin...@us.bosch.com> wrote:
Thanks for the Info, I am getting all the results, but I need to get the exact match as the first row and after that the near by match. Something like relevance order.
-----Original Message-----
From: Jack Krupansky [mailto:j...@basetechnology.com]
Sent: Thursday, February 13, 2014 9:17 AM
To: solr-user@lucene.apache.org
Subject: Re: Multiple Column Condition with Relevance/Rank
Use the OR operator between the specific clauses.
-- Jack Krupansky
-----Original Message-----
From: EXTERNAL Taminidi Ravi (ETI, Automotive-Service-Solutions)
Sent: Thursday, February 13, 2014 9:09 AM
To: solr-user@lucene.apache.org
Subject: Multiple Column Condition with Relevance/Rank
Hello, Someone can help me on implementing the below query in Solr, I will
using a rank in MS SQL and a return distinct Productid
Select productid from products where SKU = "101"
Select Productid from products where ManufactureSKU = "101"
Select Productid from product where SKU Like "101%"
Select Productid from Product where ManufactureSKU like "101%"
Select Productid from product where Name Like "101%"
Select Productid from Product where Description like '%101%"
Is there any way in Solr can search the exact match,starts with and
anywhere.. in single solr query
