USP_DATAFORMTEMPLATE_PRELOAD_ADD_EMAILFINDER

The load procedure used by the edit dataform template "EmailFinder Add Form"

Parameters

Parameter	Parameter Type	Mode	Description
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@SITEREQUIRED	bit	INOUT	Site Required
@COUNTRYID	uniqueidentifier	INOUT	Country ID
@OPTOUTFROM	nvarchar(150)	INOUT	From
@OPTOUTORG	nvarchar(150)	INOUT	Organization
@SITEID	uniqueidentifier	INOUT	Site

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_PRELOAD_ADD_EMAILFINDER
(
    @CURRENTAPPUSERID uniqueidentifier,
    @SITEREQUIRED bit = null output,
    @COUNTRYID uniqueidentifier = null output,
    @OPTOUTFROM nvarchar(150) = null output,
    @OPTOUTORG nvarchar(150) = null output,
    @SITEID uniqueidentifier = null output
)
as
begin
    set nocount on;

    set @SITEREQUIRED = dbo.UFN_SITEREQUIREDFORUSER(@CURRENTAPPUSERID);
    set @SITEID = dbo.UFN_APPUSER_DEFAULTSITEFORUSER(@CURRENTAPPUSERID);
    set @COUNTRYID = dbo.UFN_COUNTRY_GETDEFAULT();

    select top(1)
        @OPTOUTFROM = INSTALLATIONNAME,
        @OPTOUTORG = INSTALLATIONNAME
    from
        dbo.INSTALLATIONINFO;

    return 0;
end