USP_WEBDASHBOARDPAGE_ADD

Creates a new page for the web dashboard.

Parameters

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

Definition

Copy



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

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

    if @ID is null
       set @ID = newid();

    declare @WEBDASHBOARDFOLDERID uniqueidentifier;

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

    insert into dbo.WEBDASHBOARDPAGECATALOG (ID,
        NAME,
        TITLE,
        DESCRIPTION,
        WEBDASHBOARDLAYOUTID,
        OWNERID,
        WEBDASHBOARDFOLDERID,
        CONTEXTRECORDTYPEID,
        CONTEXTRECORDSEARCHLISTCATALOGID,
        ADDEDBYID,
        CHANGEDBYID,
        DATEADDED,
        DATECHANGED)
    values (@ID,
        @NAME,
        @TITLE,
        @DESCRIPTION,
        @WEBDASHBOARDLAYOUTID,
        @OWNERID,
        @WEBDASHBOARDFOLDERID,
        @CONTEXTRECORDTYPEID,
        @CONTEXTRECORDSEARCHLISTCATALOGID,
        @CHANGEAGENTID,
        @CHANGEAGENTID,
        getdate(),
        getdate());