I am trying to filter last 10 or some x minutes of data based on values in timestamp
Here is my timestamp data : "timestamp": "2023-11-08 14:28:06",
and mapping info
"timestamp": {
"type": "date",
"format": "yyyy-MM-dd HH:mm:ss"
}
I am using this query to filter
"query": {
"range": {
"timestamp": {
"gte": "now-10m/m",
"lte": "now/m",
"format": "yyyy-MM-dd HH:mm:ss"
}
}
}
what ever the timeframe I change it's always giving me the empty set.
any help would be apricated . Thank you.