Re: Multiple Column Condition with Relevance/Rank

2014-02-14 Thread Tri Cao
--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 -Origin

RE: Multiple Column Condition with Relevance/Rank

2014-02-14 Thread EXTERNAL Taminidi Ravi (ETI, Automotive-Service-Solutions)
: 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

Re: Multiple Column Condition with Relevance/Rank

2014-02-13 Thread Jack Krupansky
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

Multiple Column Condition with Relevance/Rank

2014-02-13 Thread EXTERNAL Taminidi Ravi (ETI, Automotive-Service-Solutions)
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%" Sel