# Is it possible to run dynamic sql query in elastic search

**URL:** https://discuss.elastic.co/t/is-it-possible-to-run-dynamic-sql-query-in-elastic-search/198276
**Category:** Elasticsearch
**Created:** [September 5, 2019, 2:51pm UTC](https://discuss.elastic.co/t/is-it-possible-to-run-dynamic-sql-query-in-elastic-search/198276 "2019-09-05T14:51:32Z")
**Posts on this page:** 1
**Showing post:** 3

<div class="post-metadata">

### Author: ![rameshkr1994](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rameshkr1994/32/59029_2.png) [@rameshkr1994](https://discuss.elastic.co/u/rameshkr1994)
#### Post date: [September 9, 2019, 7:06am UTC](https://discuss.elastic.co/t/is-it-possible-to-run-dynamic-sql-query-in-elastic-search/198276/3 "2019-09-09T07:06:35Z")

</div>

Hi @Christian_Dahlqvist.

Thanks

my use is below :-

please check It and please try to help.

> [@Elastic-search advanced search query issue](https://discuss.elastic.co/t/elastic-search-advanced-search-query-issue/198254/3):
>
> Hi @dadoonet. Thanks i am trying to search the records based on below sql query condition -1 condition :- 01 i have 8-fields in current index use case and i want to search all fields value based on provided value with fields like- field1:'data' field2:'sata' field5:2424 field8:PHM Condition02:- in above search field i am not providing field value for field3,4,6,7 but we need this field for next search in current query and want exact matching result with previous - field1:'data' f…

Thanks  
HadoopHelp

---

_[View the full topic](https://discuss.elastic.co/t/is-it-possible-to-run-dynamic-sql-query-in-elastic-search/198276)._