server/util/Migrator/DbScripts/2025-10-23_00_CompleteSecurityTaskByCipherIds.sql

CREATE OR ALTER PROCEDURE [dbo].[SecurityTask_MarkCompleteByCipherIds]
    @CipherIds AS [dbo].[GuidIdArray] READONLY
AS
BEGIN
    SET NOCOUNT ON

    UPDATE
        [dbo].[SecurityTask]
    SET
        [Status] = 1, -- Completed
        [RevisionDate] = SYSUTCDATETIME()
    WHERE
        [CipherId] IN (SELECT [Id] FROM @CipherIds)
        AND [Status] <> 1 -- Not already completed
END