USP_DATAFORMTEMPLATE_ADD_MKTLISTLAYOUT_PRELOAD
The load procedure used by the edit dataform template "List Layout Add Form"
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @CURRENTAPPUSERID | uniqueidentifier | IN | Input parameter indicating the ID of the current user. |
| @RECORDSOURCEID | uniqueidentifier | INOUT | Target |
| @SITEID | uniqueidentifier | INOUT | Site |
| @SITEREQUIRED | bit | INOUT | Site required? |
Definition
Copy
CREATE procedure dbo.[USP_DATAFORMTEMPLATE_ADD_MKTLISTLAYOUT_PRELOAD]
(
@CURRENTAPPUSERID uniqueidentifier,
@RECORDSOURCEID uniqueidentifier = null output,
@SITEID uniqueidentifier = null output,
@SITEREQUIRED bit = null output
)
as
set nocount on;
if (select count([ID]) from dbo.[MKTRECORDSOURCE] where dbo.[UFN_MKTRECORDSOURCE_VALIDFORPRODUCT]([ID]) = 1) = 1
select top 1 @RECORDSOURCEID = [ID] from dbo.[MKTRECORDSOURCE] where dbo.[UFN_MKTRECORDSOURCE_VALIDFORPRODUCT]([ID]) = 1;
set @SITEID = dbo.[UFN_APPUSER_DEFAULTSITEFORUSER](@CURRENTAPPUSERID);
set @SITEREQUIRED = dbo.[UFN_SITEREQUIREDFORUSERONFEATURE](@CURRENTAPPUSERID, '7B61EDD3-A6D4-49BD-960D-F476F39ABDC4', 1);
return 0;