USP_DATAFORMTEMPLATE_VIEW_EXCHANGEDOWNLOADPROCESS

The load procedure used by the view dataform template "Exchange Download Process 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.
@EMAILBATCHOWNER	nvarchar(255)	INOUT	Default email batch owner
@CONTACTBATCHOWNER	nvarchar(255)	INOUT	Default contact batch owner
@CALENDARBATCHOWNER	nvarchar(255)	INOUT	Default calendar item batch owner
@EXCLUDEPERSONAL	nvarchar(3)	INOUT	Exclude personal email
@EXCLUDEPRIVATE	nvarchar(3)	INOUT	Exclude private email
@EXCLUDECONFIDENTIAL	nvarchar(3)	INOUT	Exclude confidential email
@EXCLUDEAUTOREPLY	nvarchar(3)	INOUT	Exclude auto-reply email

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_EXCHANGEDOWNLOADPROCESS
                (
                    @ID uniqueidentifier,
                    @DATALOADED bit = 0 output,
                    @EMAILBATCHOWNER nvarchar(255) = null output,
                    @CONTACTBATCHOWNER nvarchar(255) = null output,
                    @CALENDARBATCHOWNER nvarchar(255) = null output,
                    @EXCLUDEPERSONAL nvarchar(3) = null output,
                    @EXCLUDEPRIVATE nvarchar(3) = null output, 
                    @EXCLUDECONFIDENTIAL nvarchar(3) = null output, 
                    @EXCLUDEAUTOREPLY nvarchar(3) = null output
                )
                as
                    set nocount on;

                    set @DATALOADED = 0;

                    select
                        @DATALOADED = 1,                        
                        @CONTACTBATCHOWNER = dbo.UFN_APPUSER_GETNAME(CONTACTBATCHAPPUSERID),
                        @EMAILBATCHOWNER = dbo.UFN_APPUSER_GETNAME(EMAILBATCHAPPUSERID),
                        @CALENDARBATCHOWNER = dbo.UFN_APPUSER_GETNAME(CALENDARITEMBATCHAPPUSERID),
                        @EXCLUDEPERSONAL = case EXCLUDEPERSONAL when 0 then 'No' else 'Yes' end,
                        @EXCLUDEPRIVATE = case EXCLUDEPRIVATE when 0 then 'No' else 'Yes' end, 
                        @EXCLUDECONFIDENTIAL = case EXCLUDECONFIDENTIAL when 0 then 'No' else 'Yes' end, 
                        @EXCLUDEAUTOREPLY = case EXCLUDEAUTOREPLY when 0 then 'No' else 'Yes' end
                    from
                        dbo.EXCHANGEDOWNLOADPROCESS
                    where
                        ID = @ID;

                    return 0;