Solr search query over multiple fields

Question

Is it possible to search in Solr over two fields using two different words and get back only those results which contain both of them?

For example, if I have fields "type" and "location" , I want only those results who have type='furniture' and location = 'office' in them.

Jayendra · Accepted Answer · 2013-04-18T05:51:47.900

79

You can use boolean operators and search on individual fields.

q=type:furniture AND location:office

If the values are fixed, it is better to use Filter Queries for Performance.

fq=type:furniture AND location:office

edited Apr 18 '13 at 05:51

answered Nov 11 '11 at 05:44

Jayendra

52,349
4
80
90

3

Whenever you have a query like this which uses AND, it is a good idea to consider changing it to use a filter query `fq=` because that can be faster. – Michael Dillon Nov 18 '11 at 05:56
1

yup ... agreed. If the requirement is filter rather than search, fq should be applied always. – Jayendra Nov 18 '11 at 06:00
2

Please provide comments when voting down an answer. Sure helps. – Jayendra Feb 03 '14 at 09:31
Can you please suggest how can I do Solrnet query if I wanted to do a FQ? – Ankita May 17 '16 at 05:09

score 6 · Answer 2 · edited Sep 01 '14 at 09:41

The suggested solutions have the drawback, that you have to care about escaping special characters. If the user searches for "type:d'or AND location:coffee break" the query will fail.

I suggest to combine two edismax handlers:

 <requestHandler name="/combine" class="solr.SearchHandler" default="false">
     <lst name="invariants">
       <str name="q">
        (_query_:"{!edismax qf='type' v=$uq1}"
   AND _query_:"{!edismax qf='location' v=$uq2}")
       </str>
     </lst>
  </requestHandler>

Call the request handler like this:

http://localhost:8983/solr/collection1/combine?uq1=furniture&uq2=office

Explanation

The variables $uq1 and $uq2 will be replaced by the request parameters uq1 and uq2 will.
The result of the first edismax query (uq1) is combined by logical AND with the second edismax query (uq2)

Solr Docs

https://wiki.apache.org/solr/LocalParams

score 5 · Answer 3 · answered Nov 11 '11 at 05:48

5

You can also use the boostQuery function on the dismaxRequest handler as

type=dismax&bq=type:furniture AND location:office

answered Nov 11 '11 at 05:48

A Null Pointer

2,261
3
26
28

score 3 · Answer 4 · answered Jan 09 '14 at 03:33

3

fq=type:furniture AND location:office

Instead of using AND, this could be break into two filter queries as well.

fq=type:furniture
fq=location:office

answered Jan 09 '14 at 03:33

Sapumal Jayaratne

169
6

Solr search query over multiple fields

4 Answers4

Linked