AnsweredAssumed Answered

Find previous event frame

Question asked by DonKiser on Oct 1, 2020
Latest reply on Oct 1, 2020 by DonKiser




I am generating event frames for a process (production, cleaning). I need to search by date/time for 'EventFrame1'

I then need to find the event frame previous to 'EventFrame1'.


In more common terms:


Search for the the production event for line 1 (Current) based on date/time entered by user

Search backwards for the previous production event - This is what I'm hoping there's a shortcut for.

I will then use previous End Time and Current start time to frame a new query to find a different event frame type (Cleaning).