USP_DATAFORMTEMPLATE_PRELOAD_FEEDALERTINSTANCE

The load procedure used by the edit dataform template "Feed Alert Instance Add Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ALERTTYPEID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@DATALISTCONTEXTRECORDTYPEID	uniqueidentifier	INOUT	Data list context record type
@DATALISTCONTEXTRECORDTYPENAME	nvarchar(100)	INOUT	Data list context record type name
@DATALISTCONTEXTSEARCHLISTID	uniqueidentifier	INOUT	Data list context search list ID
@DATALISTSPECXML	xml	INOUT	Data list spec xml

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_PRELOAD_FEEDALERTINSTANCE
                    (
                        @ALERTTYPEID uniqueidentifier,
                        @DATALISTCONTEXTRECORDTYPEID uniqueidentifier = null output,
                        @DATALISTCONTEXTRECORDTYPENAME nvarchar(100) = null output,
                        @DATALISTCONTEXTSEARCHLISTID uniqueidentifier = null output,
                        @DATALISTSPECXML xml = null output
                    )
                    as
                    set nocount on;

                    select
                        @DATALISTCONTEXTRECORDTYPEID = DATALISTCATALOG.RECORDTYPEID,
                        @DATALISTCONTEXTRECORDTYPENAME = RECORDTYPE.NAME,
                        @DATALISTCONTEXTSEARCHLISTID = RECORDTYPE.DEFAULTSEARCHLISTID,
                        @DATALISTSPECXML = DATALISTCATALOG.DATALISTSPEC
                    from ALERTTYPE
                    inner join dbo.DATALISTCATALOG on DATALISTCATALOG.ID = ALERTTYPE.DATALISTID
                    left join dbo.RECORDTYPE on RECORDTYPE.ID = DATALISTCATALOG.RECORDTYPEID
                    where ALERTTYPE.ID = @ALERTTYPEID;