elasticsearch bool query combine must with OR

Question

I am currently trying to migrate a solr-based application to elasticsearch   I have this lucene query          name   foo  bar       OR info   foo  bar      AND state  1  AND  has image  0  OR has image  1  100    As far as I understand this is a combination of MUST clauses combined with boolean OR     Get all documents containing  foo AND bar in name  OR  foo AND bar in info   After that filter results by condition state 1 and boost documents that have an image    I have been trying to use a bool query with MUST but I am failing to get boolean OR into must clauses  Here is what I have   GET  test object  search      from   0     size   20     sort           score    desc          query          bool            must                          match                  name    foo                                              match                  name    bar                                        must not              should                          match                  has image                    query   1                 boost   100                                                           As you can see  MUST conditions for  info  are missing   Does anyone have a solution   Thank you so much      UPDATE     I have updated my elasticsearch query and got rid of that function score  My base problem still exists

User · Answer

If you were using Solr s default or Lucene query parser  you can pretty much always put it into a query string query   POST test  search      query          query string            query       name   foo  bar  OR info   foo  bar      AND state  1  AND  has image  0  OR has image  1  100                 That said  you may want to use a boolean query  like the one you already posted  or even a combination of the two

User · Answer

I recently had to solve this problem too  and after a LOT of trial and error I came up with this  in PHP  but maps directly to the DSL     query    gt         bool    gt             should    gt                  prefix    gt    name first    gt   query                  prefix    gt    name last    gt   query                  prefix    gt    phone    gt   query                  prefix    gt    email    gt   query                                   multi match    gt                         query    gt   query                       type    gt   cross fields                        operator    gt   and                        fields    gt    name first    name last                                                       minimum should match    gt  1           filter    gt                  term    gt    state    gt   active                   term    gt    company id    gt   companyId                       Which maps to something like this in SQL   SELECT   from  lt index gt   WHERE       name first LIKE   lt query gt    OR     name last LIKE   lt query gt    OR     phone LIKE    lt query gt    OR     email LIKE   lt query gt      AND state    active  AND company id    lt query gt    The key in all this is the minimum should match setting  Without this the filter totally overrides the should    Hope this helps someone

User · Answer

filterQuery    this- gt queryFactory- gt create QueryInterface  TYPE BOOL    must    gt   queries  should   gt  queriesGeo      In must you need to add the query condition array which you want to work with AND and in should you need to add the query condition which you want to work with OR   You can check this  https   github com Smile-SA elasticsuite issues 972

User · Answer

This is how you can nest multiple bool queries in one outer bool query this using Kibana   bool indicates we are using boolean must is for AND should is for OR  GET my inedx my type  search      quot query quot            quot bool quot                   bool indicates we are using boolean operator            quot must quot              must is for   AND                                      quot match quot                              quot description quot     quot some text quot                                                                               quot match quot                              quot type quot     quot some Type quot                                                                             quot bool quot                 here its a nested boolean query                          quot should quot         should is for   OR                                                                      quot match quot                                             ur query                                                                                                                                          quot match quot                                                                                                                                                    This is how you can nest a query in ES  There are more types in  quot bool quot  like   Filter must not

User · Answer

OR is spelled should AND is spelled must NOR is spelled should not   Example   You want to see all the items that are  round AND  red OR blue            query              bool                  must                                            term     shape    round                                                             bool                              should                                   term     color    red                                   term     color    blue                                                                                                        You can also do more complex versions of OR  for example if you want to match at least 3 out of 5  you can specify 5 options under  should  and set a  minimum should  of 3   Thanks to Glen Thompson and Sebastialonso for finding where my nesting wasn t quite right before   Thanks also to Fatmajk for pointing out that  term  becomes  match  in ElasticSearch 6

User · Answer

I finally managed to create a query that does exactly what i wanted to have   A filtered nested boolean query  I am not sure why this is not documented  Maybe someone here can tell me   Here is the query   GET  test object  search      from   0     size   20     sort           score    desc          query          filtered            filter              bool                must                                  term                      state   1                                                                     query              bool                should                                  bool                      must                                              match                            name    foo                                                                                      match                            name    bar                                                                                should                                              match                            has image                              query   1                           boost   100                                                                                                                                                 bool                      must                                              match                            info    foo                                                                                      match                            info    bar                                                                                should                                              match                            has image                              query   1                           boost   100                                                                                                                                           minimum should match   1                                     In pseudo-SQL   SELECT   FROM  test object WHERE        name foo AND name bar  OR  info foo AND info bar   AND state 1   Please keep in mind that it depends on your document field analysis and mappings how name foo is internally handled  This can vary from a fuzzy to strict behavior    minimum should match   1 says  that at least one of the should statements must be true   This statements means that whenever there is a document in the resultset that contains has image 1 it is boosted by factor 100  This changes result ordering    should              match            has image              query   1           boost   100                         Have fun guys

[elasticsearch] elasticsearch bool query combine must with OR

Examples related to elasticsearch