CODEWITHSUNDEEP
elasticsearchelastic-stackelasticsearch-5elasticsearch-query
Tirumalesh
Tirumalesh

Reputation: 95

Filter query is not working in elastic search

I have document and search query as below elastic is not able to fetch the documents for the matched exception id's initially while creating the index i have done the mapping and after that it is not able to fetch the records

and my mapping looks like below

{
  "mappings": {
    "properties": {
      "events": {
        "type": "nested",
        "properties": {
          "data": {
            "type": "nested",
            "properties": {
              "comments": {
                "type": "nested",
                "properties": {
                  "type": {
                    "type": "keyword"
                  }
                }
              }
            }
          }
        }
      }
    }
  }
}

here is my index document which i am testing against using the search query.

{
  "id": "1",
  "score": 1,
  "comments": [{
    "id": "1",
    "type": "Delayed",

Upvotes: 0

Views: 495

Answers (1)

jaspreet chahal
jaspreet chahal

Reputation: 9109

You cannot directly use query-string on nested fields, You need to use nested query for it

GET <index-name>/_search
{
  "query": {
    "bool": {
      "filter": [
        {
          "nested": { --> note
            "path": "events.recommendationData",
            "query": {
              "query_string": {
                "query": "\"1\" OR \"2\"",
                "fields": [
                  "events.recommendationData.exceptionId"
                ],
                "type": "best_fields",
                "default_operator": "or",
                "max_determinized_states": 10000,
                "enable_position_increments": true,
                "fuzziness": "AUTO",
                "fuzzy_prefix_length": 0,
                "fuzzy_max_expansions": 50,
                "phrase_slop": 0,
                "escape": false,
                "auto_generate_synonyms_phrase_query": true,
                "fuzzy_transpositions": true,
                "boost": 1
              }
            }
          }
        }
      ]
    }
  },
  "size": 1, --> note, to return documents ,keep 0 for only aggs
  "aggs": {
            "genres": {
                "nested": {
                    "path": "events.recommendationData.recommendations"
                },
                "aggs": {
                    "nested_comments_recomms": {
                        "terms": {
                            "field": "events.recommendationData.recommendations.recommendationType"
                        }
                    }
                }
            }
        }
}

Upvotes: 1

Related Questions