Hello everyone, I want to filter the time


(BlueMonster) #1

I have a question, I want to filter the time, how to do?
To filter queries by time, I would like to find out the relevant information of the specified time period, such as the November 23, 2015 16:41:35 to November 24, 2015 16:41:42 to orderNo=238349292 field of information


(BlueMonster) #2

My English is very poor , thants!


(BlueMonster) #3

This is my JSON

{
"query": {
"bool": {
"must": {
"match_all": {}
},
"filter": {
"range": {
"timestamp": {
"gte": "2015-11-18 10:23:01:915",
"lte": "2015-11-19 10:23:01:915"
}
}
}
}
}
}


(Isabel Drost-Fromm) #4

Can you please also post some example data you indexed (minimal version to show your point would be sufficient) and the expected output you want to see?

If you are feeling uncomfortable asking your question in English - maybe there's an "Elasticsearch in your native tongue" forum category that suits you?

Isabel


(system) #6