# Range query on multi-value field? **URL:** \ **Category:** Elasticsearch\ **Created:** [February 4, 2015, 12:07pm UTC](https://discuss.elastic.co/t/range-query-on-multi-value-field/21973 "2015-02-04T12:07:15Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![Rural\_Hunter](https://avatars.discourse-cdn.com/v4/letter/r/e9a140/32.png) [@Rural\_Hunter](https://discuss.elastic.co/u/Rural_Hunter)\ **Post date:** [February 4, 2015, 12:07pm UTC](https://discuss.elastic.co/t/range-query-on-multi-value-field/21973/1 "2015-02-04T12:07:15Z")
I have a field with multi values like this: "100, 200, 300,1000". I need to get the docs which contains any value from 100 to 500 in this filed. Is it possible to run a range query against this multi-value field? -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/CAOe1oo8Xm\_6h-xQNjLz%2B85h-c3QHR8LXC%2BbTn-gYt9\_9i078gg%40mail.gmail.com](https://groups.google.com/d/msgid/elasticsearch/CAOe1oo8Xm_6h-xQNjLz%2B85h-c3QHR8LXC%2BbTn-gYt9_9i078gg%40mail.gmail.com). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![johtani](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/johtani/32/44956_2.png) [@johtani](https://discuss.elastic.co/u/johtani)\ **Post date:** [February 5, 2015, 2:36am UTC](https://discuss.elastic.co/t/range-query-on-multi-value-field/21973/2 "2015-02-05T02:36:59Z")
Hi Rural, Yes. An example is following POST /multi\_valued/sample/1 { "prices" : [100,200,300,1000] } POST /multi\_valued/sample/2 { "prices" : [400,1000] } GET /multi\_valued/sample/\_search { "query": { "range": { "prices": { "gte”: 100, "lte": 300 } } } } -\> Results : 1 GET /multi\_valued/sample/\_search { "query": { "range": { "prices": { "gte": 600, "lte": 1000 } } } } -\> Results 1 and 2 Does it make sense? * * * Jun Ohtani [johtani@gmail.com](mailto:johtani@gmail.com) blog : [http://blog.johtani.info](http://blog.johtani.info) twitter : [http://twitter.com/johtani](http://twitter.com/johtani) > 2015/02/04 21:07、Rural Hunter [ruralhunter@gmail.com](mailto:ruralhunter@gmail.com) のメール： > > I have a field with multi values like this: "100, 200, 300,1000". I need to get the docs which contains any value from 100 to 500 in this filed. Is it possible to run a range query against this multi-value field? > > -- > You received this message because you are subscribed to the Google Groups "elasticsearch" group. > To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). > To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/CAOe1oo8Xm\_6h-xQNjLz%2B85h-c3QHR8LXC%2BbTn-gYt9\_9i078gg%40mail.gmail.com](https://groups.google.com/d/msgid/elasticsearch/CAOe1oo8Xm_6h-xQNjLz%2B85h-c3QHR8LXC%2BbTn-gYt9_9i078gg%40mail.gmail.com). > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/E21E36FE-446F-4862-AA38-B6EF4C44D74E%40gmail.com](https://groups.google.com/d/msgid/elasticsearch/E21E36FE-446F-4862-AA38-B6EF4C44D74E%40gmail.com). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![Rural\_Hunter](https://avatars.discourse-cdn.com/v4/letter/r/e9a140/32.png) [@Rural\_Hunter](https://discuss.elastic.co/u/Rural_Hunter)\ **Post date:** [February 5, 2015, 3:29am UTC](https://discuss.elastic.co/t/range-query-on-multi-value-field/21973/3 "2015-02-05T03:29:58Z")
yes, that's what I wanted. Thanks a lot! 2015-02-05 10:36 GMT+08:00 Jun Ohtani [johtani@gmail.com](mailto:johtani@gmail.com): > Hi Rural, > > Yes. An example is following > > POST /multi\_valued/sample/1 > { > "prices" : [100,200,300,1000] > } > > POST /multi\_valued/sample/2 > { > "prices" : [400,1000] > } > > GET /multi\_valued/sample/\_search > { > "query": { > "range": { > "prices": { > "gte”: 100, > "lte": 300 > } > } > } > } > > -\> Results : 1 > > GET /multi\_valued/sample/\_search > { > "query": { > "range": { > "prices": { > "gte": 600, > "lte": 1000 > } > } > } > } > > -\> Results 1 and 2 > > Does it make sense? > > * * * > > Jun Ohtani > [johtani@gmail.com](mailto:johtani@gmail.com) > blog : [http://blog.johtani.info](http://blog.johtani.info) > twitter : [http://twitter.com/johtani](http://twitter.com/johtani) > > > 2015/02/04 21:07、Rural Hunter [ruralhunter@gmail.com](mailto:ruralhunter@gmail.com) のメール： > > > > I have a field with multi values like this: "100, 200, 300,1000". I need > > to get the docs which contains any value from 100 to 500 in this filed. Is > > it possible to run a range query against this multi-value field? > > > > -- > > You received this message because you are subscribed to the Google > > Groups "elasticsearch" group. > > To unsubscribe from this group and stop receiving emails from it, send > > an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). > > To view this discussion on the web visit > > [https://groups.google.com/d/msgid/elasticsearch/CAOe1oo8Xm\_6h-xQNjLz%2B85h-c3QHR8LXC%2BbTn-gYt9\_9i078gg%40mail.gmail.com](https://groups.google.com/d/msgid/elasticsearch/CAOe1oo8Xm_6h-xQNjLz%2B85h-c3QHR8LXC%2BbTn-gYt9_9i078gg%40mail.gmail.com) > > . > > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). > > -- > You received this message because you are subscribed to the Google Groups > "elasticsearch" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). > To view this discussion on the web visit > [https://groups.google.com/d/msgid/elasticsearch/E21E36FE-446F-4862-AA38-B6EF4C44D74E%40gmail.com](https://groups.google.com/d/msgid/elasticsearch/E21E36FE-446F-4862-AA38-B6EF4C44D74E%40gmail.com) > . > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/CAOe1oo9B3PbjCiJXoRV868aghyUDAfqoqHhPAeMsossQbhRhmw%40mail.gmail.com](https://groups.google.com/d/msgid/elasticsearch/CAOe1oo9B3PbjCiJXoRV868aghyUDAfqoqHhPAeMsossQbhRhmw%40mail.gmail.com). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**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, 12:34am UTC](https://discuss.elastic.co/t/range-query-on-multi-value-field/21973/4 "2017-07-06T00:34:54Z")