USP_WEBDASHBOARDPAGE_MOVE

Moves a web dashboard page to a new folder.

Parameters

Parameter	Parameter Type	Mode
@CURRENTNAME	nvarchar(200)	IN
@CURRENTFOLDERPATH	nvarchar(1000)	IN
@NEWNAME	nvarchar(200)	IN
@NEWFOLDERPATH	nvarchar(1000)	IN
@NEWTITLE	nvarchar(200)	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy



create procedure dbo.USP_WEBDASHBOARDPAGE_MOVE(@CURRENTNAME nvarchar(200), 
    @CURRENTFOLDERPATH nvarchar(1000),
    @NEWNAME nvarchar(200),
    @NEWFOLDERPATH nvarchar(1000),
    @NEWTITLE nvarchar(200),
    @CHANGEAGENTID uniqueidentifier)
as
    set nocount on;

    declare @CURRENTWEBDASHBOARDFOLDERID uniqueidentifier;
    declare @NEWWEBDASHBOARDFOLDERID uniqueidentifier;

    select @CURRENTWEBDASHBOARDFOLDERID = ID from dbo.WEBDASHBOARDFOLDER where PATH = @CURRENTFOLDERPATH;
    select @NEWWEBDASHBOARDFOLDERID = ID from dbo.WEBDASHBOARDFOLDER where PATH = @NEWFOLDERPATH;

    update dbo.WEBDASHBOARDPAGECATALOG set NAME = @NEWNAME,
        WEBDASHBOARDFOLDERID = @NEWWEBDASHBOARDFOLDERID,
        TITLE = @NEWTITLE,
        CHANGEDBYID = @CHANGEAGENTID,
        DATECHANGED = getdate()
    where NAME = @CURRENTNAME
        and (WEBDASHBOARDFOLDERID is null and @CURRENTWEBDASHBOARDFOLDERID is null or WEBDASHBOARDFOLDERID = @CURRENTWEBDASHBOARDFOLDERID);