USP_RECORDOPERATION_HTMLTEMPLATEMERGETODOCXPROCESSCLEARRESULTS

Executes the "Html Template Merge to Docx Process: Clear Results" record operation.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	Input parameter indicating the ID of the record being updated.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the update.

Definition

Copy



create procedure dbo.USP_RECORDOPERATION_HTMLTEMPLATEMERGETODOCXPROCESSCLEARRESULTS
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier
)
as begin
    if @CHANGEAGENTID is null  
      exec dbo.[USP_CHANGEAGENT_GETORCREATECHANGEAGENT] @CHANGEAGENTID output;

    declare @HTMLTEMPLATEMERGETODOCXOUTPUTID uniqueidentifier;
    declare @CURRENTDATE datetime = getdate();

    select 
        @HTMLTEMPLATEMERGETODOCXOUTPUTID = HTMLTEMPLATEMERGETODOCXOUTPUT.ID
    from 
        HTMLTEMPLATEMERGETODOCXOUTPUT
    where
        HTMLTEMPLATEMERGETODOCXOUTPUT.HTMLTEMPLATETODOCXMERGEPROCESSSTATUSID = @ID

    begin try
        exec dbo.USP_HTMLTEMPLATEMERGETODOCXOUTPUT_DELETEBYID_WITHCHANGEAGENTID @HTMLTEMPLATEMERGETODOCXOUTPUTID, @CHANGEAGENTID

        --Set the status message to 'Results cleared' for this process status...

        update dbo.[BUSINESSPROCESSSTATUS] set 
          [STATUSCODE] = 3,
          [CHANGEDBYID] = @CHANGEAGENTID,
          [DATECHANGED] = @CURRENTDATE
        where [ID] = @ID;
    end try
    begin catch
        exec dbo.[USP_RAISE_ERROR];
        return 1;
    end catch

    return 0;
end