ElasticSearch – Get only matching nested objects with All Top level fields in search response

by

If you’re ok with having all root fields except the nested one and then only the matching inner hits in the nested field, then we can re-use the previous answer like this by specifying a slightly more involved source filtering parameter:

{
  "_source": {
    "includes": [ "*" ],
    "excludes": [ "users" ]
  },
  "query": {
    "nested": {
      "path": "users",
      "inner_hits": {        <---- this is where the magic happens
        "_source": [
          "name", "surname"
        ]
      },
      "query": {
        "bool": {
          "must": [
            {
              "term": {
                "users.name": "abc"
              }
            }
          ]
        }
      }
    }
  }
}

More Related Contents:

  1. How to search for a part of a word with ElasticSearch
  2. no [query] registered for [filtered]
  3. ES keeps returning every document
  4. Elasticsearch: Failed to connect to localhost port 9200 – Connection refused
  5. Calculating time between events
  6. Make elasticsearch only return certain fields?
  7. Remove duplicate documents from a search in Elasticsearch
  8. Elasticsearch 2.1: Result window is too large (index.max_result_window)
  9. Elasticsearch searchable synthetic fields
  10. Why do I need “store”:”yes” in elasticsearch?
  11. How to not-analyze in ElasticSearch?
  12. Find distinct values, not distinct counts in elasticsearch
  13. Save Spark Dataframe into Elasticsearch – Can’t handle type exception
  14. How to retrieve unique count of a field using Kibana + Elastic Search
  15. Elasticsearch difference between MUST and SHOULD bool query
  16. How to change Elasticsearch max memory size
  17. Can We Retrieve Previous _source Docs with Elastic Search Versions
  18. What is the maximum Elasticsearch document size?
  19. Elasticsearch, Tire, and Nested queries / associations with ActiveRecord
  20. How to iterate through a nested array in elasticsearch with filter script?
  21. elasticsearch – querying multiple indexes is possible?
  22. Elasticsearch – set max_clause_count
  23. How to bind Elasticsearch 2.0 on both Loopback and Non-Loopback interfaces?
  24. ElasticSearch: aggregation on _score field?
  25. How to parse json in logstash /grok from a text file line?
  26. Logstash: Merge two logs into one output document
  27. Remove a field from a Elasticsearch document
  28. Elasticsearch error: cluster_block_exception [FORBIDDEN/12/index read-only / allow delete (api)], flood stage disk watermark exceeded
  29. What is the ElasticSearch equivalent for an SQL subquery?
  30. How to create multiple indexes in logstash.conf file?

Leave a Comment