# Match only if query is found in a field found within a specific nested object, and nothing else

**URL:** <https://discuss.elastic.co/t/match-only-if-query-is-found-in-a-field-found-within-a-specific-nested-object-and-nothing-else/215539>\
**Category:** Elasticsearch\
**Created:** [January 18, 2020, 1:23am UTC](https://discuss.elastic.co/t/match-only-if-query-is-found-in-a-field-found-within-a-specific-nested-object-and-nothing-else/215539 "2020-01-18T01:23:25Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![RedactedProfile](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/redactedprofile/32/9426_2.png) [@RedactedProfile](https://discuss.elastic.co/u/RedactedProfile)\
**Post date:** [January 18, 2020, 1:23am UTC](https://discuss.elastic.co/t/match-only-if-query-is-found-in-a-field-found-within-a-specific-nested-object-and-nothing-else/215539/1 "2020-01-18T01:23:25Z")

</div>

Let's assume my index's data looks something like this:

```
[
  {
    "_index": "doc_pages",
    "_type": "pages",
    "_id": "264b406593732ffbd15a5ed4b4e3b5af",
    "_score": 1,
    "_source": {
      "record_id": "264b406593732ffbd15a5ed4b4e3b5af",
      "title": "Page Title 1",
      "title_exact": "Page Title 1",
      "versions": [
        {
          "page_id": "fbaf1d5c-dff0-42bb-a41b-3248f0d115d0",
          "page_slug": "page-title-1",
          "page_content": "Page Title 1 You can test whether the instances were configured properly. Refer to Page Title 1.",
          "document_id": "0cfc5f29-ad3e-11e8-8784-00505692583a",
          "document_title": "Document Title 1",
          "document_slug": "document-title-1",
          "software_version": "5.6.3"
        },
        {
          "page_id": "d6d717e2-1868-4f6d-b93d-e42d15f68058",
          "page_slug": "connectivity-test",
          "page_content": "Page Title 1 You can test whether the instances were configured properly. Refer to Page Title 1.",
          "document_id": "012fca84-1911-11e9-b86b-00505692583a",
          "document_title": "Document Title 1",
          "document_slug": "document-title-1",
          "software_version": "6.0.0"
        }
      ]
    }
  },
  {
    "_index": "doc_pages",
    "_type": "pages",
    "_id": "c47b24da3e68e2c854ed8bc0436e7384",
    "_score": 1,
    "_source": {
      "record_id": "c47b24da3e68e2c854ed8bc0436e7384",
      "title": "Introduction",
      "title_exact": "Introduction",
      "versions": [
        {
          "page_id": "6329c7fb-a1f1-4fd9-ae78-0db702c411f5",
          "page_slug": "introduction",
          "page_content": "Introduction You can configure with two instances using Highly Available Virtual IP, which is configurable on the platform.",
          "document_id": "0cfc5f29-ad3e-11e8-8784-00505692583a",
          "document_title": "Document Title 1",
          "document_slug": "document-title-1",
          "software_version": "5.6.3"
        },
        {
          "page_id": "c091675c-7e82-4533-a78e-688770be7ce7",
          "page_slug": "introduction",
          "page_permanent_id": "647589",
          "page_content": "Introduction You can configure with two instances using Highly Available Virtual IP (HAVIP), which is configurable on the platform.",
          "document_id": "012fca84-1911-11e9-b86b-00505692583a",
          "document_title": "Document Title 1",
          "document_slug": "document-title-1",
          "software_version": "6.0.0"
        }
      ]
    }
  }
]

```

And my query currently looks like this

```
{
  "size": 30,
  "query": {
    "bool": {
      "minimum_should_match": 1,
      "filter": {
        "nested": {
          "path": "versions",
          "query": [
            {
              "term": {
                "versions.document_id": "0cfc5f29-ad3e-11e8-8784-00505692583a"
              }
            }
          ]
        }
      },
      "should": [
        {
          "dis_max": {
            "queries": [
              {
                "term": {
                  "title_exact": "HAVIP"
                }
              },
              {
                "query_string": {
                  "fields": [
                    "title"
                  ],
                  "query": "HAVIP"
                }
              },
              {
                "nested": {
                  "path": "versions",
                  "query": {
                    "query_string": {
                      "fields": [
                        "versions.page_content"
                      ],
                      "query": "HAVIP"
                    }
                  }
                }
              }
            ]
          }
        }
      ]
    }
  }
}

```

The problem that I face right now is that record id `c47b24da3e68e2c854ed8bc0436e7384` will show up in my results. That's the complaint. ES found the string reliably, and the filter is correct in that this Document ID was apart of it.

What we're trying to resolve now is to make the search a bit less forgiving, and make things a bit more explicit. So now, the situation is that the **query** can only exist inside the **version object** that matches the provided **document id** , while performing a similar query.

At this point, I'm not quite sure how to get ElasticSearch to care about **only looking into** a very specific sub object based off of a term match

Any help on this matter would be very much appreciated.

ES version is 6.3.2

Cheers!

---

<div class="post-metadata">

**Author:** ![RedactedProfile](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/redactedprofile/32/9426_2.png) [@RedactedProfile](https://discuss.elastic.co/u/RedactedProfile)\
**Post date:** [January 21, 2020, 9:42pm UTC](https://discuss.elastic.co/t/match-only-if-query-is-found-in-a-field-found-within-a-specific-nested-object-and-nothing-else/215539/2 "2020-01-21T21:42:29Z")

</div>

Alright cool, so "impossible" is what I'm hearing? 😉

---

<div class="post-metadata">

**Author:** ![Fabio-sama](https://avatars.discourse-cdn.com/v4/letter/f/b9e5f3/32.png) [@Fabio-sama](https://discuss.elastic.co/u/Fabio-sama)\
**Post date:** [January 23, 2020, 11:19am UTC](https://discuss.elastic.co/t/match-only-if-query-is-found-in-a-field-found-within-a-specific-nested-object-and-nothing-else/215539/3 "2020-01-23T11:19:12Z")

</div>

> [@RedactedProfile](#):
>
> 0cfc5f29-ad3e-11e8-8784-00505692583a

I'm afraid I didn't really get what you're looking for.

Given that input, which would be your desired output?  
Would you like only the nested object to be returned? This one I mean:

```
{
  "page_id": "6329c7fb-a1f1-4fd9-ae78-0db702c411f5",
  "page_slug": "introduction",
  "page_content": "Introduction You can configure with two instances using Highly Available Virtual IP, which is configurable on the platform.",
  "document_id": "0cfc5f29-ad3e-11e8-8784-00505692583a",
  "document_title": "Document Title 1",
  "document_slug": "document-title-1",
  "software_version": "5.6.3"
}

```

Also, I'm not really sure that query might even work as you say since you're looking for a nested object in path `versions` when versions has no nested object in it (it has only an array of objects, which is quite different).

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [February 20, 2020, 11:19am UTC](https://discuss.elastic.co/t/match-only-if-query-is-found-in-a-field-found-within-a-specific-nested-object-and-nothing-else/215539/4 "2020-02-20T11:19:13Z")

</div>

Closed on February 20, 2020, 11:19am UTC

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.