I have a field called "request", I want to output all the log lines in history if the request value presents in certain date range. for example.
1/1/2018 10:00:00 x0
1/2/2018 11:00:00 x1
1/3/2018 10:00::00 x2
1/5/2018 10:00:00 x2
1/5/2018 11:00:00 x5
if 1/5/2018 if the date range, only x2, x5's history will return. Any idea how to do that?
PS: in the real world, the records' number is very large , there may be millions before the 1/1/2018 to the 1/5/2018.
You can add to the query the following - earliest=1503982800&latest=1504760400
. Please use the following for converting a date to an epoch time - Epoch & Unix Timestamp Conversion Tools
my expected result is:
1/3/2018 10:00::00 x2
1/5/2018 10:00:00 x2
1/5/2018 11:00:00 x5
not 1/5/2018 10:00:00 x2
1/5/2018 11:00:00 x5