I am using ES to analysis medical data. how can i using painless script compare these two time values(beginDateTime, endDateTime).deep values. if it's not deep value, i found a solution like this
Hi Aron, thanks for your kindly reply, what puzzles me is the data structure, I don't know how to use the painless script in DSL to get these two values. In Kibana, Lucene is easy to get the values, but can't compare them.
Goodmorning
I want to compare the beginDateTime and endDateTime exact to second (yyyy-mm-dd hh24:mi: ss).
If the endDateTime is before < the beginDateTime, returned all query records.
No need to create a new field, just use these query records in Kibana(Find records with time logic errors in medical data)
Now. I solved this problem. it's a nested layer query problem, I am not familiar with the solution of this kind matter before.
Here is my code. Hope it can be helpful to those who also have problems with query nested data
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant
logo are trademarks of the
Apache Software Foundation
in the United States and/or other countries.