Re: Count record that resets by date

[Matt Newville via Tech-talk <tech-talk@aps.anl.gov>]

Daniel,

On Wed, Mar 13, 2019 at 4:02 PM Daniel Cuneo via Tech-talk <tech-talk@aps.anl.gov> wrote:

Hi all,

I'd like to create a database record that counts based on a forward link. This record would need to reset back to zero 

at 12AM every day. 

Use case, is where a beam line user hits a reset button repeatably (tied to a bo record) as a work around for something that is broken.

I'd like to track these resets.

Is there a way to do this with base?

I'm considering writing a C subroutine for this is it doesn't already exist.

Cheers!

dpc

If the use-case is to track resets of a bo record, why not use a script that sets up a monitor on the bo record and writes the value and timestamp of each event to a file?  Or you could add the bo record to whatever archiver you're using and extract the events from that.   Either way, such an event log would let you can slice the event data any way you want (not just "per day") and you haven't erased the information every day at midnight. 

--Matt Newville