# Add filter range in request

**URL:** https://discuss.elastic.co/t/add-filter-range-in-request/29228
**Category:** Elasticsearch
**Created:** [September 14, 2015, 9:45am UTC](https://discuss.elastic.co/t/add-filter-range-in-request/29228 "2015-09-14T09:45:21Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![Smasell](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/smasell/32/43483_2.png) [@Smasell](https://discuss.elastic.co/u/Smasell)
#### Post date: [September 14, 2015, 9:45am UTC](https://discuss.elastic.co/t/add-filter-range-in-request/29228/1 "2015-09-14T09:45:21Z")

</div>

Hi!!!  
I have a request:

```
{
"size": 10000, 
"filter": {
"term": {
"user_id": "254337"
}
},
"query": {
"bool": {
"should" : [
{
 "term" : { "event" : "logged_in" }
},
{
"term" : { "event" : "deauthorize" }
}
],
"minimum_number_should_match": 1
}
},
"sort": [
 {
 "@timestamp": {
 "order": "asc"
 }
 }
] 
}

```

And I need to add range filter to my request:

```
"filter": 
{
"range": {
"@timestamp": {
"gt": "now-1h"
}
}
}

```

where i can put it?

---

<div class="post-metadata">

### Author: ![Mark\_Harwood](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mark_harwood/32/10538_2.png) [@Mark\_Harwood](https://discuss.elastic.co/u/Mark_Harwood)
#### Post date: [September 14, 2015, 11:20am UTC](https://discuss.elastic.co/t/add-filter-range-in-request/29228/2 "2015-09-14T11:20:15Z")

</div>

Multiple filters to queries can be arranged with a `must` clause like this:

```
GET test/doc/_search
{
   "size": 10000,
   "query": {
	  "filtered": {
		 "query": {
			"bool": {
			   "should": [
				  {
					 "term": {
						"event": "logged_in"
					 }
				  },
				  {
					 "term": {
						"event": "deauthorize"
					 }
				  }
			   ],
			   "minimum_number_should_match": 1
			}
		 },
		 "filter": {
			"bool": {
			   "must": [
				  {
					 "range": {
						"@timestamp": {
						   "gt": "now-1h"
						}
					 }
				  },
				  {
					 "term": {
						"user_id": "254337"
					 }
				  }
			   ]
			}
		 }
	  }
   },
   "sort": [
	  {
		 "@timestamp": {
			"order": "asc"
		 }
	  }
   ]
}
```

---

<div class="post-metadata">

### Author: ![Smasell](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/smasell/32/43483_2.png) [@Smasell](https://discuss.elastic.co/u/Smasell)
#### Post date: [September 14, 2015, 12:40pm UTC](https://discuss.elastic.co/t/add-filter-range-in-request/29228/3 "2015-09-14T12:40:38Z")

</div>

THX it works!!!

---

<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:50pm UTC](https://discuss.elastic.co/t/add-filter-range-in-request/29228/4 "2017-07-05T23:50:28Z")

</div>


