USP_DATAFORMTEMPLATE_VIEW_INTERACTIONPREVIEW

The load procedure used by the view dataform template "Constituent Interaction Preview View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@EXPECTEDDATE	datetime	INOUT	Expected date
@ACTUALDATE	datetime	INOUT	Actual date
@STATUS	nvarchar(100)	INOUT	Status
@OBJECTIVE	nvarchar(100)	INOUT	Summary
@RESPONSES	xml	INOUT	Responses
@OWNER	nvarchar(154)	INOUT	Owner
@EVENT	nvarchar(154)	INOUT	Event
@TYPE	nvarchar(100)	INOUT	Type

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_INTERACTIONPREVIEW(
                    @ID uniqueidentifier,
                    @DATALOADED bit = 0 output,
                    @EXPECTEDDATE datetime = null output,
                    @ACTUALDATE datetime = null output,
                    @STATUS nvarchar(100) = null output,
                    @OBJECTIVE nvarchar(100) = null output,
                    @RESPONSES xml = null output,
                    @OWNER nvarchar(154) = null output,
                    @EVENT nvarchar(154) = null output,
                    @TYPE nvarchar(100) = null output
                ) as begin
                    set nocount on;

                    set @DATALOADED = 0;

                    select
                        @DATALOADED = 1,
                        @EXPECTEDDATE = EXPECTEDDATE,
                        @ACTUALDATE = ACTUALDATE,
                        @STATUS = STATUS,
                        @OBJECTIVE = OBJECTIVE,
                        @RESPONSES = dbo.UFN_INTERACTION_GETRESPONSES_TOITEMLISTXML(@ID),
                        @TYPE = dbo.UFN_INTERACTIONTYPECODE_GETDESCRIPTION(INTERACTION.INTERACTIONTYPECODEID),
                        @OWNER = CONSTITUENT.NAME,
                        @EVENT  = EVENT.NAME
                    from 
                        dbo.INTERACTION
                        left join dbo.CONSTITUENT on dbo.CONSTITUENT.ID = dbo.INTERACTION.FUNDRAISERID
                        left join dbo.EVENT on dbo.EVENT.ID = dbo.INTERACTION.EVENTID
                    where
                        INTERACTION.ID = @ID

                    return 0

                end