USP_RECORDOPERATION_REPORTDELETE

Executes the "Report: Delete" record operation.

Parameters

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

Definition

Copy



CREATE procedure dbo.USP_RECORDOPERATION_REPORTDELETE(@ID uniqueidentifier, @CHANGEAGENTID uniqueidentifier)
as
    set nocount on;

    -- Delete the report.

    exec dbo.USP_REPORTCATALOG_DELETEBYID_WITHCHANGEAGENTID @ID, @CHANGEAGENTID;

    declare @contextCache varbinary(128);

    /* cache current context information */
    set @contextCache = CONTEXT_INFO();

    /* set CONTEXT_INFO to @CHANGEAGENTID */
    if not @CHANGEAGENTID is null
        set CONTEXT_INFO @CHANGEAGENTID;

    -- Delete any tasks that currently point to this report.

    with XMLNAMESPACES('bb_appfx_commontypes' as ct, 'bb_appfx_task' as t)
    delete from dbo.TASKCATALOG where TASKCATALOG.TASKSPECXML.value('(/t:TaskSpec/ct:ShowReport/@ReportID)[1]', 'uniqueidentifier') = @ID;

    /* reset CONTEXT_INFO to previous value */
    if not @contextCache is null
        set CONTEXT_INFO @contextCache;

    return 0;