# Hello everyone, I want to filter the time

**URL:** <https://discuss.elastic.co/t/hello-everyone-i-want-to-filter-the-time/35395>\
**Category:** Elasticsearch\
**Created:** [November 24, 2015, 8:42am UTC](https://discuss.elastic.co/t/hello-everyone-i-want-to-filter-the-time/35395 "2015-11-24T08:42:19Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![liweigao](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/liweigao/32/6736_2.png) [@liweigao](https://discuss.elastic.co/u/liweigao)\
**Post date:** [November 24, 2015, 8:42am UTC](https://discuss.elastic.co/t/hello-everyone-i-want-to-filter-the-time/35395/1 "2015-11-24T08:42:19Z")

</div>

I have a question, I want to filter the time, how to do?  
To filter queries by time, I would like to find out the relevant information of the specified time period, such as the November 23, 2015 16:41:35 to November 24, 2015 16:41:42 to orderNo=238349292 field of information

---

<div class="post-metadata">

**Author:** ![liweigao](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/liweigao/32/6736_2.png) [@liweigao](https://discuss.elastic.co/u/liweigao)\
**Post date:** [November 24, 2015, 8:43am UTC](https://discuss.elastic.co/t/hello-everyone-i-want-to-filter-the-time/35395/2 "2015-11-24T08:43:23Z")

</div>

My English is very poor , thants!

---

<div class="post-metadata">

**Author:** ![liweigao](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/liweigao/32/6736_2.png) [@liweigao](https://discuss.elastic.co/u/liweigao)\
**Post date:** [November 24, 2015, 8:57am UTC](https://discuss.elastic.co/t/hello-everyone-i-want-to-filter-the-time/35395/3 "2015-11-24T08:57:55Z")

</div>

This is my JSON

{  
"query": {  
"bool": {  
"must": {  
"match\_all": {}  
},  
"filter": {  
"range": {  
"timestamp": {  
"gte": "2015-11-18 10:23:01:915",  
"lte": "2015-11-19 10:23:01:915"  
}  
}  
}  
}  
}  
}

---

<div class="post-metadata">

**Author:** ![mainec](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mainec/32/5557_2.png) [@mainec](https://discuss.elastic.co/u/mainec)\
**Post date:** [November 24, 2015, 12:14pm UTC](https://discuss.elastic.co/t/hello-everyone-i-want-to-filter-the-time/35395/4 "2015-11-24T12:14:28Z")

</div>

> [@liweigao](#):
>
> This is my JSON

Can you please also post some example data you indexed (minimal version to show your point would be sufficient) and the expected output you want to see?

> [@liweigao](#):
>
> My English is very poor , thants!

If you are feeling uncomfortable asking your question in English - maybe there's an "Elasticsearch in your native tongue" forum category that suits you?

Isabel

---

<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:36pm UTC](https://discuss.elastic.co/t/hello-everyone-i-want-to-filter-the-time/35395/6 "2017-07-05T23:36:08Z")

</div>


