Querying time interval with LoggingDB

[pierrebarroca]

When I do a query for given time interval I retrieve empty data.

This issue can be easily replicated with the LHC_Panel notebook in the examples querying a single measurement like this on cell 6 now=time.time() now_minus_a_day = now - 3600*24 ib1="LHC.BCTDC.A6R4.B1:BEAM_INTENSITY" ib2="LHC.BCTDC.A6R4.B2:BEAM_INTENSITY" nrg="LHC.BOFSU:OFSU_ENERGY" data=db.get(ib1,now_minus_a_day,now)

gives {'LHC.BCTDC.A6R4.B1:BEAM_INTENSITY': (array([], dtype=float64), array([], dtype=float64))}

querying a single datetime works

[pierrebarroca]

Here is an example.

[rdemaria]

With one timestamp you get the last data point before the timestamp. Are you sure this record is in between ts1 and ts2? What happens when the data range is larger?

[pierrebarroca]

I got the issue now. Thank you for the help.