# ElasticSearch Range query lte , gte issue **URL:** \ **Category:** Elasticsearch\ **Created:** [August 19, 2014, 7:49pm UTC](https://discuss.elastic.co/t/elasticsearch-range-query-lte-gte-issue/19349 "2014-08-19T19:49:41Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![srikanth\_ramineni](https://avatars.discourse-cdn.com/v4/letter/s/aca169/32.png) [@srikanth\_ramineni](https://discuss.elastic.co/u/srikanth_ramineni)\ **Post date:** [August 19, 2014, 7:49pm UTC](https://discuss.elastic.co/t/elasticsearch-range-query-lte-gte-issue/19349/1 "2014-08-19T19:49:41Z")
Hi , I am facing some issue while retrieving data using range query.. can some one provide me help on this. In index i have two columns like MAX\_QTY MIN\_QTY 1000 50 I have a quantity 100 with me.. I need to get all records where 100 fall betwen mixqty and maxqty. Appreciate your help. Thanks, Srikanth. -- 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/34dcd4bd-8d79-47c9-b1d3-7ea0c96c073b%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/34dcd4bd-8d79-47c9-b1d3-7ea0c96c073b%40googlegroups.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, 1:07am UTC](https://discuss.elastic.co/t/elasticsearch-range-query-lte-gte-issue/19349/2 "2017-07-06T01:07:37Z")