USP_WEBDASHBOARDPAGE_EDIT

Updates an existing web dashboard page.

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@NAME	nvarchar(200)	IN
@TITLE	nvarchar(200)	IN
@DESCRIPTION	nvarchar(1000)	IN
@PATH	nvarchar(1000)	IN
@CONTEXTRECORDTYPEID	uniqueidentifier	IN
@CONTEXTRECORDSEARCHLISTCATALOGID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy



create procedure dbo.USP_WEBDASHBOARDPAGE_EDIT(@ID uniqueidentifier,
    @NAME nvarchar(200),
    @TITLE nvarchar(200),
    @DESCRIPTION nvarchar(1000),
    @PATH nvarchar(1000),
    @CONTEXTRECORDTYPEID uniqueidentifier,
    @CONTEXTRECORDSEARCHLISTCATALOGID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier)
as
    set nocount on;

    if @CHANGEAGENTID is null
        exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

    declare @WEBDASHBOARDFOLDERID uniqueidentifier;

    select @WEBDASHBOARDFOLDERID = ID from dbo.WEBDASHBOARDFOLDER where PATH = @PATH;

    update dbo.WEBDASHBOARDPAGECATALOG set NAME = @NAME,
        TITLE = @TITLE,
        DESCRIPTION = @DESCRIPTION,
        WEBDASHBOARDFOLDERID = @WEBDASHBOARDFOLDERID,
        CONTEXTRECORDTYPEID = @CONTEXTRECORDTYPEID,
        CONTEXTRECORDSEARCHLISTCATALOGID = @CONTEXTRECORDSEARCHLISTCATALOGID,
        CHANGEDBYID = @CHANGEAGENTID,
        DATECHANGED = getdate()
    where ID = @ID;