USP_DATAFORMTEMPLATE_VIEW_INVITATIONHISTORY

The load procedure used by the view dataform template "Invitation History 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.
@BUSINESSPROCESSSTATUSID	uniqueidentifier	INOUT	BUSINESSPROCESSSTATUSID
@PARAMETERSETID	uniqueidentifier	INOUT	PARAMETERSETID
@COMPLETED	nvarchar(5)	INOUT	COMPLETED
@NAME	nvarchar(100)	INOUT	Name
@STARTEDBY	nvarchar(128)	INOUT	Started by
@STARTEDON	datetime	INOUT	Started

Definition

Copy


                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_INVITATIONHISTORY
                (
                    @ID uniqueidentifier,
                    @DATALOADED bit = 0 output,
                    @BUSINESSPROCESSSTATUSID uniqueidentifier = null output,
                    @PARAMETERSETID uniqueidentifier = null output,
                    @COMPLETED nvarchar(5) = null output,
                    @NAME nvarchar(100) = null output,                    
                    @STARTEDBY nvarchar(128) = null output,
                    @STARTEDON datetime = null output
                )
                as
                    set nocount on;

                    set @DATALOADED = 0;

                    select
                        @DATALOADED = 1,
                        @BUSINESSPROCESSSTATUSID = INVITATIONHISTORY.BUSINESSPROCESSSTATUSID,
                        @PARAMETERSETID = INVITATIONSTATUS.PARAMETERSETID,
                        @COMPLETED =
                            case
                                when (BUSINESSPROCESSSTATUS.STATUSCODE = 0) then
                                    'True'
                                else
                                    'False'
                            end,
                        @NAME =
                            case
                                when INVITATIONHISTORY.NAME = '' then
                                    'Process is starting...'
                                else
                                    INVITATIONHISTORY.NAME
                            end,
                        @STARTEDBY = STARTEDBY.USERNAME,
                        @STARTEDON = BUSINESSPROCESSSTATUS.STARTEDON
                    from
                        dbo.INVITATIONHISTORY
                        left join dbo.INVITATIONSTATUS on INVITATIONHISTORY.BUSINESSPROCESSSTATUSID = INVITATIONSTATUS.ID
                        left join dbo.BUSINESSPROCESSSTATUS on INVITATIONHISTORY.BUSINESSPROCESSSTATUSID = BUSINESSPROCESSSTATUS.ID
                        left join dbo.APPUSER STARTEDBY on BUSINESSPROCESSSTATUS.STARTEDBYUSERID = STARTEDBY.ID
                    where
                        INVITATIONHISTORY.ID = @ID;

                    return 0;