8 Replies Latest reply on Dec 12, 2018 1:58 PM by sraposo

    How to acknowledge Event Frames in bulk using SQL commander?

    Maitreyi

      We have thousands of Event Frames to be acknowledged manually. Instead I was using the following query to acknowledge an EVENT Frame but it spits out with '[SQL Analyzer] Internal compiler error.'. Any idea why?

       

      Query:

      UPDATE [TEST].[EventFrame].[EventFrame]

      SET Acknowledged = DATE(),

      AcknowledgedBy = 'XXXX'

      where StartTime < '2018-03-13 00:00:00'

      AND Acknowledged IS NULL