USP_DATAFORMTEMPLATE_ADD_APPEALMAILINGSETUP_MINIMAL_PRELOAD

The load procedure used by the edit dataform template "Appeal Mailing Add Data Form For Minimal Data Ext"

Parameters

Parameter	Parameter Type	Mode	Description
@SELECTIONLISTS	xml	INOUT
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@CONSTITUENTRECORDTYPEID	uniqueidentifier	INOUT	Constituent record type

Definition

Copy


          CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_APPEALMAILINGSETUP_MINIMAL_PRELOAD
          (
            @SELECTIONLISTS xml = null output,
              @CURRENTAPPUSERID uniqueidentifier,
            @CONSTITUENTRECORDTYPEID uniqueidentifier = null output
          )
          as
          begin
              select @CONSTITUENTRECORDTYPEID = [ID] from dbo.[RECORDTYPE] where upper([NAME]) = 'CONSTITUENT';

              select
                  @CONSTITUENTRECORDTYPEID as CONSTITUENTRECORDTYPEID,
                  (select [NAME] as GROUPNAME from dbo.[UFN_SELECTION_GETGROUPNAMES](@CONSTITUENTRECORDTYPEID) for xml raw('ITEM'),type,elements,root('SELECTIONLISTS'),binary base64) as SELECTIONLISTS,
                  dbo.[UFN_MKTSEGMENTATION_GETREQUIREDANDDEFAULTSOLICITCODEEXCLUSIONS_TOITEMLISTXML](@CURRENTAPPUSERID) as SELECTEDEXCLUSIONS,
                  (select top(1) [ID] from dbo.[ADDRESSPROCESSINGOPTION] where [ISDEFAULT] = 1 and dbo.[UFN_SITEALLOWEDFORUSER](@CURRENTAPPUSERID, [SITEID]) = 1) as ADDRESSPROCESSINGOPTIONID,
                  (select top(1) [ID] from dbo.[NAMEFORMATPARAMETER] where [ISDEFAULT] = 1 and dbo.[UFN_SITEALLOWEDFORUSER](@CURRENTAPPUSERID, [SITEID]) = 1) as NAMEFORMATPARAMETERID
          end