HTTP GET Query with range


(Charles Moulliard) #1

Hi,

This query works very well (http://localhost:9200/insight-*/_search?q=_type%3Asta-camel&pretty=true) and returns from my ES database (1.3.2) records

{ "_shards": { "failed": 0, "successful": 5, "total": 5 }, "hits": { "hits": [ { "_id": "dAJK0cI2RSucDJa0506AQQ", "_index": "insight-2015.11.25", "_score": 1.0, "_source": { "@timestamp": "2015-11-25T11:39:20.352+01", "camel-spring-rest": { "routes": { "route1": { "ExchangesCompleted": "0", "ExchangesFailed": "0", "ExchangesTotal": "0", "ExternalRedeliveries": "0", "FailuresHandled": "0", "InflightExchanges": "0", "Load01": "0.0", "Load05": "0.0", "Load15": "0.0", "MaxProcessingTime": "0", "MeanProcessingTime": "0", "MinProcessingTime": "0", "Redeliveries": "0", "TotalProcessingTime": "0" } } }, "host": "rest" }, "_type": "sta-camel" },

But, when I try to define a range for the dates, the result is empty

http://localhost:9200/insight-*/_search?q=_type%3Asta-camel+AND+timestamp%3A%5B2014-05-01+TO+2015-11-26%5D&pretty=true

Is my request correct or wrong ?

Regards,

Charles


(Charles Moulliard) #2

Found my error "timestamp" -> "@timestamp"

/insight-*/_search?q=_type%3Asta-camel+AND+%40timestamp%3A%5B2015-11-25+TO+2015-11-27%5D&pretty=true


(Mark Walkom) #3

FYI 1.3.2 is EOL, I'd suggest you upgrade! :slight_smile:


(system) #4