# Nearby Query with Dynamic Data

**URL:** https://discuss.elastic.co/t/nearby-query-with-dynamic-data/300800
**Category:** Elasticsearch
**Created:** [March 28, 2022, 5:18am UTC](https://discuss.elastic.co/t/nearby-query-with-dynamic-data/300800 "2022-03-28T05:18:42Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![kabilsharma](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/kabilsharma/32/100503_2.png) [@kabilsharma](https://discuss.elastic.co/u/kabilsharma)
#### Post date: [March 28, 2022, 5:18am UTC](https://discuss.elastic.co/t/nearby-query-with-dynamic-data/300800/1 "2022-03-28T05:18:42Z")

</div>

(Nearby Query)

We are building a search engine where user will type like

1. Restaurant (Category) in Delhi (place)

2. Bar (Category) in Mumbai (place)

We are supposed to search first tag into category and second tag into place.

So the final query would be something like

First we need to get the Lat, Long from places and then make the second query as a nearby from lat long.

"query": "hotel",  
"search\_fields": {  
"category": {}  
},  
"result\_fields": {  
"category": {  
"raw": {}  
},  
"name": {  
"raw": {}

```
},
"filters": {
    "location": { // our field key 
        "center": [
             (lat, Long) ( this should be dynamic coming from another query. A match with places)  
        ],
        "distance": 15,
        "unit": "km"
    }
```

---

<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: [March 28, 2022, 6:35am UTC](https://discuss.elastic.co/t/nearby-query-with-dynamic-data/300800/2 "2022-03-28T06:35:01Z")

</div>

If you pull the lat, long out, then pass it into the query in your code it'll work. Otherwise Elasticsearch cannot merge things that way, no.

---

<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: [April 25, 2022, 6:35am UTC](https://discuss.elastic.co/t/nearby-query-with-dynamic-data/300800/3 "2022-04-25T06:35:50Z")

</div>

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