AnsweredAssumed Answered

How to acknowledge Event Frames in bulk using SQL commander?

Question asked by Maitreyi on Nov 19, 2018
Latest reply on Dec 12, 2018 by sraposo

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

Outcomes