# Elasticsearch Query
**URL:** https://discuss.elastic.co/t/elasticsearch-query/246332
**Category:** Elasticsearch
**Created:** [August 25, 2020, 5:05pm UTC](https://discuss.elastic.co/t/elasticsearch-query/246332 "2020-08-25T17:05:19Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@sundarcse1216](https://discuss.elastic.co/u/sundarcse1216)
#### Post date: [August 25, 2020, 5:05pm UTC](https://discuss.elastic.co/t/elasticsearch-query/246332/1 "2020-08-25T17:05:19Z")
Hi All,
I have record in Elasticsearch index like below. Can any one pls help me for curl query with following conditions.
**Conditions** :
1. Type must be 'A'
2. user must be 'U1' OR 'U3'
3. date range between '8/22/2020' and '8/28/2020'
**SQL:**
select \* from table1 where type="A" and user in("U1","U3") and date between "8/21/2020" and "8/28/2020"
expecting elastic query against above SQL query.
| **id** | **type** | **user** | **date** |
|1|A|U1|8/20/2020|
|2|A|U2|8/21/2020|
|3|A|U3|8/22/2020|
|4|E|U1|8/23/2020|
|5|A|U3|8/24/2020|
|6|A|U3|8/25/2020|
|7|E|U1|8/26/2020|
|8|A|U2|8/27/2020|
|9|A|U1|8/28/2020|
|10|A|U1|8/29/2020|
---
### Author:  [@warkolm](https://discuss.elastic.co/u/warkolm)
#### Post date: [August 26, 2020, 4:28am UTC](https://discuss.elastic.co/t/elasticsearch-query/246332/2 "2020-08-26T04:28:33Z")
What have you tried so far?
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [September 23, 2020, 4:28am UTC](https://discuss.elastic.co/t/elasticsearch-query/246332/3 "2020-09-23T04:28:42Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.