Date range query wrong results


(Delegen Admin) #1

When submitting the query below (also mapping attached), we are getting all records indexed, instead of only the records between the date range.

Query:
{"query": {"range" : { "status_changed_date" : { "gte": "02/10/17 10:33:32" } } }}

Mappings:
{
"green" : {
"mappings" : {
"location" : {
"properties" : {
"contactMethod" : {
"type" : "text",
"fields" : {
"keyword" : {
"type" : "keyword",
"ignore_above" : 256
}
}
},
"lat" : {
"type" : "float"
},
"lng" : {
"type" : "float"
},
"name" : {
"type" : "text",
"fields" : {
"keyword" : {
"type" : "keyword",
"ignore_above" : 256
}
}
},
"phoneNums" : {
"type" : "text",
"fields" : {
"keyword" : {
"type" : "keyword",
"ignore_above" : 256
}
}
},
"status" : {
"type" : "text",
"fields" : {
"keyword" : {
"type" : "keyword",
"ignore_above" : 256
}
}
},
"status_changed_date" : {
"type" : "date",
"format" : "dd/MM/yy HH:mm:ss"
}
}
}
}
}
}


(system) #2

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.