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.

Reply via email to