Hmmm strange. Well I if you don't need scoring you should also use filters instead of queries. Try this one (works for me):
"query" : { "filtered" : { "query" : { "query_string" : { "query" : "*" } }, "filter" : { "bool" : { "must" : { "range" : { "DateTime" : { "gt" : "....", "lte" : "...." } } } } } } } Am Donnerstag, 9. April 2015 15:27:08 UTC+2 schrieb James Crone: > > Same problem. :( > > On Thursday, April 9, 2015 at 6:25:25 PM UTC+5, Jan Wolf wrote: >> >> I would try "must" instead of "should" :) >> >> Am Dienstag, 7. April 2015 10:55:01 UTC+2 schrieb James Crone: >>> >>> Hello! >>> >>> My query is this: >>> >>> GET _search >>> { >>> "query": { >>> "bool": { >>> "should": [ >>> { >>> "range": { >>> "DateTime": { >>> "gt": "2015-03-01", >>> "lte": "2015-03-09" >>> } >>> } >>> } >>> ] >>> } >>> } >>> } >>> Result is: >>> >>> { >>> "took": 2, >>> "timed_out": false, >>> "_shards": { >>> "total": 11, >>> "successful": 11, >>> "failed": 0 >>> }, >>> "hits": { >>> "total": 1, >>> "max_score": 1, >>> "hits": [ >>> { >>> "_index": "completedata", >>> "_type": "users", >>> "_id": "1", >>> "_score": 1, >>> "_source": { >>> "ID": 1, >>> "User_ID": 1, >>> "Name": "Saudia Arabia Bomb", >>> "Text": "Saudia Arabia Bomb", >>> "Status": "online", >>> "DateTime": "2015-03-10T00:00:00.000+05:00", >>> "categories_ID": 1 >>> } >>> } >>> ] >>> } >>> } >>> >>> mapping for date is: >>> >>> "DateTime" : { >>> "type" : "date", >>> "format" : "dateOptionalTime" >>> } >>> >>> It returns me the result of "2015-03-10".How can i get exact result by >>> matching Date? Any Idea? >>> >>> >>> >>> >>> >>> -- 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+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/58895cc8-f680-44ea-9ded-96af0dae36cf%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.