Search on multiple fields with Elasticsearch

Question

I'm new to Elasticsearch and I'm wondering how I can make a search specifing one or more fields.

With SQL I would write this query:

"SELECT field1, field2, field3 FROM tablename WHERE field1 = 'X' AND field2 != 'Y' AND field3 = 'Z'" 

In Elasticsearch I'm starting from this:

{     "query": {         "filtered": {             "query": {                 "query_string": {                     "query": "*"                 }             },             "filter": {                 "term" : {                     "field1" : "286"                 }             }         }     } } 

Answer 1

The sql query is equivalent to:

{   "query": {     "bool": {       "must": [         {           "term": {             "field1": "X"           }         },         {           "term": {             "field3": "Z"           }         }       ],       "must_not": {         "term": {           "field2": "Y"         }       }     }   } } 

In any case I recommend you to read a bit the doc before starting with elasticsearch if you are new.

There are lots of types of queries and some of them depends on how you index your data, for example for strings, you can analyze strings (lowercase, stem words, remove stopwords, ...) at index time. The query I posted will never match a doc whose field1 is "X" if you analyze that field at index time and convert it to lower case.

Once you know a little bit better elasticsearch you can use filters for improving your queries.