# Query with Nested, Location and script

**URL:** https://discuss.elastic.co/t/query-with-nested-location-and-script/38057
**Category:** Elasticsearch
**Created:** [December 28, 2015, 3:23pm UTC](https://discuss.elastic.co/t/query-with-nested-location-and-script/38057 "2015-12-28T15:23:48Z")
**Posts on this page:** 7
**Page:** 1

<div class="post-metadata">

### Author: ![jordans](https://avatars.discourse-cdn.com/v4/letter/j/c67d28/32.png) [@jordans](https://discuss.elastic.co/u/jordans)
#### Post date: [December 28, 2015, 3:23pm UTC](https://discuss.elastic.co/t/query-with-nested-location-and-script/38057/1 "2015-12-28T15:23:48Z")

</div>

Hi all,

I'm Jordan and i work on a search engine. I need some help writting a script...

This is a part of my query :

 ![](https://us1.discourse-cdn.com/elastic/original/2X/a/ac60f0a06a4f0c96d304b7b1a78fb32f4e388fb5.png)

And the error is: "failed to run inline script [doc['services.distance'].value \<= doc['location'].arcDistanceInKm(lat, lon)] using lang [groovy]"; "groovy\_script\_execution\_exception";

---

<div class="post-metadata">

### Author: ![reiiz](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/reiiz/32/6867_2.png) [@reiiz](https://discuss.elastic.co/u/reiiz)
#### Post date: [December 28, 2015, 6:35pm UTC](https://discuss.elastic.co/t/query-with-nested-location-and-script/38057/2 "2015-12-28T18:35:57Z")

</div>

Hi,

I have a very similar issue, if someone could help with this, it would be great.

Thanks.

---

<div class="post-metadata">

### Author: ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)
#### Post date: [December 28, 2015, 8:19pm UTC](https://discuss.elastic.co/t/query-with-nested-location-and-script/38057/3 "2015-12-28T20:19:39Z")

</div>

Just checking, do you have scripting enabled?

---

<div class="post-metadata">

### Author: ![jordans](https://avatars.discourse-cdn.com/v4/letter/j/c67d28/32.png) [@jordans](https://discuss.elastic.co/u/jordans)
#### Post date: [December 28, 2015, 11:18pm UTC](https://discuss.elastic.co/t/query-with-nested-location-and-script/38057/4 "2015-12-28T23:18:03Z")

</div>

I think...

 ![](https://us1.discourse-cdn.com/elastic/original/2X/b/bcbbfb5755a108ad13c3c55562298e82ebe09696.png)

---

<div class="post-metadata">

### Author: ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)
#### Post date: [December 28, 2015, 11:19pm UTC](https://discuss.elastic.co/t/query-with-nested-location-and-script/38057/5 "2015-12-28T23:19:24Z")

</div>

It's a lot easier if you just paste the text, rather than a screenshot of that text.

However that looks correct.

---

<div class="post-metadata">

### Author: ![jordans](https://avatars.discourse-cdn.com/v4/letter/j/c67d28/32.png) [@jordans](https://discuss.elastic.co/u/jordans)
#### Post date: [December 30, 2015, 12:13am UTC](https://discuss.elastic.co/t/query-with-nested-location-and-script/38057/6 "2015-12-30T00:13:18Z")

</div>

I post all my query... If you see an error.

`{ "query": { "bool": { "filter": [{ "nested": { "path": "stores", "query": { "bool": { "filter": [ { "match": { "stores.id": 1 } }, { "or": [ { "match": { "stores.active_distance": false } }, { "and": [ { "match": { "stores.active_distance": true } }, { "script": { "script": { "params": { "lat": 12.345678, "lon": 12.345678 }, "lang": "groovy", "inline": "doc['stores.distance'].value >= doc['location'].arcDistanceInKm(lat, lon)" } } } ] } ] } ] } } } }, { "not": { "match": { "_id": 2 } } } ] } } }`

---

<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: [July 5, 2017, 11:27pm UTC](https://discuss.elastic.co/t/query-with-nested-location-and-script/38057/7 "2017-07-05T23:27:58Z")

</div>