# Range query acts like wildcard search

**URL:** <https://discuss.elastic.co/t/range-query-acts-like-wildcard-search/4663>\
**Category:** Elasticsearch\
**Created:** [June 20, 2011, 9:08pm UTC](https://discuss.elastic.co/t/range-query-acts-like-wildcard-search/4663 "2011-06-20T21:08:39Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![mobsniuk](https://avatars.discourse-cdn.com/v4/letter/m/d6d6ee/32.png) [@mobsniuk](https://discuss.elastic.co/u/mobsniuk)\
**Post date:** [June 20, 2011, 9:08pm UTC](https://discuss.elastic.co/t/range-query-acts-like-wildcard-search/4663/1 "2011-06-20T21:08:39Z")

</div>

{  
"query": {  
"range": {  
"hits": {  
"from": 58,  
"to": 60  
}  
}  
}  
}

Is my query but I get values back like "58", "5825", "5932". Below is  
a snippet of the json returned.

@fields: {  
view: [  
"\_default"  
]  
size: [  
"169994"  
]  
hits: [  
"5932"  
]  
misses: [  
1"02"  
]  
timestamp: [  
"2011-06-18T19:06:23-07:00"  
]  
YEAR: [  
"2011"  
]  
MONTHNUM: [  
"06"  
]  
MONTHDAY: [  
"18"  
]  
HOUR: [  
"19",07"  
]  
MINUTE: [  
"06","00"  
]  
SECOND: [  
"23"  
]  
ISO8601\_TIMEZONE: [  
"-07:00"  
]  
caller: [  
"daemon"  
]  
process: [  
"named"  
]  
pid: [  
"26353"  
]  
BASE10NUM: [  
"26353"  
]  
data: [  
"info Recursion cache view "\_default": size = 169994, hits = 5932,  
misses = 102"  
]  
}

Mark

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [June 20, 2011, 9:31pm UTC](https://discuss.elastic.co/t/range-query-acts-like-wildcard-search/4663/2 "2011-06-20T21:31:01Z")

</div>

Hits doesn't seem to be a number value as it's surrounding by "" in data field.

What is the exact mapping you have ?

David 😉

Le 20 juin 2011 à 23:08, Mark [mobsniuk@gmail.com](mailto:mobsniuk@gmail.com) a écrit :

> {  
> "query": {  
> "range": {  
> "hits": {  
> "from": 58,  
> "to": 60  
> }  
> }  
> }  
> }
> 
> Is my query but I get values back like "58", "5825", "5932". Below is  
> a snippet of the json returned.
> 
> @fields: {  
> view: [  
> "\_default"  
> ]  
> size: [  
> "169994"  
> ]  
> hits: [  
> "5932"  
> ]  
> misses: [  
> 1"02"  
> ]  
> timestamp: [  
> "2011-06-18T19:06:23-07:00"  
> ]  
> YEAR: [  
> "2011"  
> ]  
> MONTHNUM: [  
> "06"  
> ]  
> MONTHDAY: [  
> "18"  
> ]  
> HOUR: [  
> "19",07"  
> ]  
> MINUTE: [  
> "06","00"  
> ]  
> SECOND: [  
> "23"  
> ]  
> ISO8601\_TIMEZONE: [  
> "-07:00"  
> ]  
> caller: [  
> "daemon"  
> ]  
> process: [  
> "named"  
> ]  
> pid: [  
> "26353"  
> ]  
> BASE10NUM: [  
> "26353"  
> ]  
> data: [  
> "info Recursion cache view "\_default": size = 169994, hits = 5932,  
> misses = 102"  
> ]  
> }
> 
> Mark

---

<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 6, 2017, 4:03am UTC](https://discuss.elastic.co/t/range-query-acts-like-wildcard-search/4663/3 "2017-07-06T04:03:05Z")

</div>