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

--