USP_WEBDASHBOARDPERSONALIZATIONPERUSER_DELETE

Deletes a user's personalization data for a web dashboard page.

Parameters

Parameter	Parameter Type	Mode
@WEBDASHBOARDPAGENAME	nvarchar(200)	IN
@WEBDASHBOARDPATH	nvarchar(1000)	IN
@APPUSERID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy



CREATE procedure dbo.USP_WEBDASHBOARDPERSONALIZATIONPERUSER_DELETE(@WEBDASHBOARDPAGENAME nvarchar(200),
    @WEBDASHBOARDPATH nvarchar(1000),
    @APPUSERID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier)
as
    set nocount on;

    declare @WEBDASHBOARDPAGEID uniqueidentifier;
    declare @ID uniqueidentifier;

    select @WEBDASHBOARDPAGEID = WEBDASHBOARDPAGECATALOG.ID 
    from dbo.WEBDASHBOARDPAGECATALOG 
    left join dbo.WEBDASHBOARDFOLDER on WEBDASHBOARDPAGECATALOG.WEBDASHBOARDFOLDERID = WEBDASHBOARDFOLDER.ID
    where WEBDASHBOARDPAGECATALOG.NAME = @WEBDASHBOARDPAGENAME and ((@WEBDASHBOARDPATH = '' and WEBDASHBOARDPAGECATALOG.WEBDASHBOARDFOLDERID is null) or WEBDASHBOARDFOLDER.PATH = @WEBDASHBOARDPATH);

    if @WEBDASHBOARDPAGEID is null
    begin
        raiserror('The page does not exist, or it cannot be customized by the current user.', 16, 1);
        return;
    end;

    select @ID = ID 
    from dbo.WEBDASHBOARDPERSONALIZATIONPERUSER
    where WEBDASHBOARDPAGEID = @WEBDASHBOARDPAGEID
        and APPUSERID = @APPUSERID;

    exec dbo.USP_WEBDASHBOARDPERSONALIZATIONPERUSER_DELETEBYID_WITHCHANGEAGENTID @ID, @CHANGEAGENTID;