ElasticSearch fulltext search with bool query

Question

I am trying to make full-text search in whole document using

"query" => [
    "query_string" => [
        "fields" => ["_all"],
        "query" => "fooA AND fooB"
    ]
]

It works pretty good. In the same query I need to run bool query

"query" => [
    "bool" => [
        "must" => [
            "term" => [
                "name" => "My_name"
            ]
        ],
        "should" => [
            ....
        ]
    ]
]

Is it possible to combine these two queries ? is this proper way to make full-text search ?

In result I need all documents that contains "fooA AND fooB" in any field and special field name equals "My_name".

Rahul · Answer 1 · 2017-03-18T17:05:19.960

0

Yes, you can club these together as shown below :

GET _search
{
  "from": 0,
  "size": 20,
  "query": {
    "bool": {
      "must": [
        {
          "term": {
            "name": "MY_NAME"
          }
        },
        {
          "query_string": {
            "query": "fooA AND fooB",
            "fields": [
              "_all"
            ]
          }
        }
      ]
    }
  }
}

edited Mar 18 '17 at 17:05

answered Mar 18 '17 at 15:59

Rahul

15,979
4
42
63

No, this doesn`t work. Error : [query_string] malformed query, expected [END_OBJECT] but found [FIELD_NAME] – OdkoPP Mar 18 '17 at 16:59
Please check now. – Rahul Mar 18 '17 at 17:05

score 0 · Accepted Answer · edited May 23 '17 at 12:02

I found solution for my question thanks to this post.

"query" => [
    "bool" => [
        "must" => [
            [
                "term" => [
                    "name" => "My_name"
                ]
            ],
            [
                "query_string" => [
                    "fields" => ["_all"],
                    "query" => "fooA AND fooB"
                ]
            ]
        ]
    ]
]

This combination works for me

ElasticSearch fulltext search with bool query

2 Answers2