# Elastic DSL Query

**URL:** <https://discuss.elastic.co/t/elastic-dsl-query/319040>\
**Category:** Elasticsearch\
**Created:** [November 16, 2022, 9:05am UTC](https://discuss.elastic.co/t/elastic-dsl-query/319040 "2022-11-16T09:05:38Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Nikhil\_Sharma2](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nikhil_sharma2/32/103116_2.png) [@Nikhil\_Sharma2](https://discuss.elastic.co/u/Nikhil_Sharma2)\
**Post date:** [November 16, 2022, 9:05am UTC](https://discuss.elastic.co/t/elastic-dsl-query/319040/1 "2022-11-16T09:05:38Z")

</div>

I have a query in sql which I want to transform in ES.

Select \* from items where  
(  
(State=== Open AND (userId=== '123' OR contributers.include('123')))  
OR  
(  
(State=== Review)  
AND  
(  
AntherState=== Submitted AND AND (userId=== '123' OR contributers.include('123')))  
OR  
AntherState=== Submitted AND Type = 1)  
OR  
AntherState === Accepted AND reviewer === '123'  
)  
)  
OR  
(  
(State=== Submitted OR State=== Closed ) AND ( lastupdated = last 7 days )  
)  
)

Any help will be appreciated.

---

<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:** [December 14, 2022, 9:05am UTC](https://discuss.elastic.co/t/elastic-dsl-query/319040/2 "2022-12-14T09:05:57Z")

</div>

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