# No field found for \[path\] in mapping with types \[doc\]

**URL:** <https://discuss.elastic.co/t/no-field-found-for-path-in-mapping-with-types-doc/164568>\
**Category:** Elasticsearch\
**Created:** [January 17, 2019, 4:31am UTC](https://discuss.elastic.co/t/no-field-found-for-path-in-mapping-with-types-doc/164568 "2019-01-17T04:31:13Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![imadykyted](https://avatars.discourse-cdn.com/v4/letter/i/858c86/32.png) [@imadykyted](https://discuss.elastic.co/u/imadykyted)\
**Post date:** [January 17, 2019, 4:31am UTC](https://discuss.elastic.co/t/no-field-found-for-path-in-mapping-with-types-doc/164568/1 "2019-01-17T04:31:13Z")

</div>

My ES document model is as follows

```
       "hits": [
          {
             "_source": {
                "variant_group": {
                   "variant_info": [
                      {
                         "name": "Toothpaste",
                         "inventory": 10
                      }
                   ],
                   "type_id": 1365
                }
             },
     ]

```

when I try to execute this query in sorting:

```
         {
     "_script": {
        "type": "number",
        "order": "desc",
        "script": {
           "lang": "groovy",
           "inline": "return doc['variant_group.variant_info'].values.any{ it -> it.inventory > 0 }"
        }
     }
  }

```

following error is raised  
**No field found for [variant\_group.variant\_info] in mapping with types [merchant\_variant\_group]**

I tried using `containsKey` as follows:

```
 {
 "_script": {
"type": "number",
"order": "desc",
"script": {
   "lang": "groovy",
   "inline": "return doc.containsKey('variant_group.variant_info') ? 1 : 0"
}
 }
  }

```

this script block returns `0` and not `1`

However, if I execute this:

```
 {
 "_script": {
"type": "number",
"order": "desc",
"script": {
   "lang": "groovy",
   "inline": "return doc.containsKey('variant_group.type_id') ? 1 : 0"
}
 }
  }

```

it returns the expected response `1`

Is there a gotcha that I'm missing for collection types or is there some issue with my code?

Thanks!

---

<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 14, 2019, 4:31am UTC](https://discuss.elastic.co/t/no-field-found-for-path-in-mapping-with-types-doc/164568/2 "2019-02-14T04:31:21Z")

</div>

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