Filter with querystring in elasticsearch

Question

I send this query and it works fine. It returns filtered data:

{
    "query": {
        "bool": {
            "filter": [
                {
                    "match": {
                        "lang": "en"
                    }
                }
            ]
        }
    },
    "size": 10,
    "from": 0,
    "sort": []
}

If I want to search with searchstring then it workst fine too:

{
    "query": {
        "query_string": {
            "query": "big size"
        }
    },
    "size": 10,
    "from": 0,
    "sort": []
}

But I can't get data from elastic by filter and searchstring together:

{
    "query": {
        "query_string": {
            "query": "big size"
        },
        "bool": {
            "filter": [
                {
                    "match": {
                        "lang": "en"
                    }
                }
            ]
        }
    },
    "size": 10,
    "from": 0,
    "sort": []
}

I receive next error:

Error 400.
{"error":{"root_cause":[{"type":"parsing_exception","reason":"[query_string] malformed query, expected [END_OBJECT] but found [FIELD_NAME]","line":1,"col":76}],"type":"parsing_exception","reason":"[query_string] malformed query, expected [END_OBJECT] but found [FIELD_NAME]","line":1,"col":76},"status":400}

karthick S · Accepted Answer · 2023-01-26 06:51:13Z

1

Your query needs to be restructured as shown below.

Query:

{
  "query": {
    "bool": {
      "must": [
        {
          "query_string": {
            "query": "big size"
          }
        }
      ],
      "filter": [
        {
          "match": {
            "lang": "en"
          }
        }
      ]
    }
  },
  "size": 10,
  "from": 0,
  "sort": []
}

answered Jan 26, 2023 at 6:51

karthick S

5841 gold badge9 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Filter with querystring in elasticsearch

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related