USP_DATAFORMTEMPLATE_PRELOAD_APPUSERFEEDALERT

The load procedure used by the edit dataform template "Application User Feed Alert 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_APPUSERFEEDALERT
(
    @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;