Problem with query using a date range

Bryan_Mahoney · December 9, 2012, 7:39pm

Hi all,

I'm a relatively new ES user and I've run into an issue querying an index
with a date range attached.
The query returns data when I try it locally (ES version 0.19.8), but my
remote installation (on EC2 using version 0.19.12) won't return results.

I've recreated the index a number of times but I keep striking out.

I've created the following gist with the query in question as well as the
results returned when I omit the date range.

gist.github.com

https://gist.github.com/bryanmtl/4246638

gistfile1.txt

Query: 
curl -X GET "http://localhost:9200/spree_products/spree%2Fproduct/_search?from=0&load=false&page=1&per_page=20&size=20&pretty=true" -d '{"query":{"bool":{"must":[{"query_string":{"query":"Carry","default_operator":"AND"}},{"range":{"available_on":{"lte":"2011-12-08T11:43:53Z"}}}]}},"size":20,"from":0}'

Returns: 

{
  "took" : 7,
  "timed_out" : false,
  "_shards" : {
    "total" : 5,

This file has been truncated. show original

Any help on this would be great appreciated.

Cheers,
Bryan

--

Topic		Replies	Views
Timestamp range not querying properly Elasticsearch	6	392	July 22, 2019
Date Range query not working Elasticsearch	1	1090	July 5, 2017
So much pain on ES, query on date returns wrong results Elasticsearch	4	2320	March 16, 2018
Help understanding range query with date Elasticsearch	1	302	May 12, 2020
Date Range Query without result Elasticsearch	6	552	February 18, 2018

Problem with query using a date range

Related topics