I have a scripted field(named as exit_time) created by me.
Now i want to use this exit_time in dev console(kibana) to perform certain operations like delete,etc on documents present in the my index of elastic search.
How can i do this?Is it possible.
This is the query , i am trying in dev console of kibana
POST fqedup1/_delete_by_query?routing=1
{
"query": {
"range" : {
"difference" : {
"gte" : 17891245689
}
}
}
}
Here "difference" is a script field created by me (of type "number")
while i am executing this none of them is deleting.
output in kibana dev console:
{
"took" : 0,
"timed_out" : false,
"total" : 0,
"deleted" : 0,
"batches" : 0,
"version_conflicts" : 0,
"noops" : 0,
"retries" : {
"bulk" : 0,
"search" : 0
},
"throttled_millis" : 0,
"requests_per_second" : -1.0,
"throttled_until_millis" : 0,
"failures" :
}
in gte ,keeping any value,getting same output