UFN_MKTSOURCECODE_GETDEFAULTPASSIVESOURCECODEID
Returns the ID of the default source code available to the current user applicable to public media marketing efforts.
Return
| Return Type |
|---|
| uniqueidentifier |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @CURRENTAPPUSERID | uniqueidentifier | IN | |
| @SECURITYFEATUREID | uniqueidentifier | IN | |
| @SECURITYFEATURETYPE | tinyint | IN |
Definition
Copy
CREATE function dbo.[UFN_MKTSOURCECODE_GETDEFAULTPASSIVESOURCECODEID]
(
@CURRENTAPPUSERID uniqueidentifier,
@SECURITYFEATUREID uniqueidentifier,
@SECURITYFEATURETYPE tinyint
)
returns uniqueidentifier
as
begin
declare @SOURCECODEID uniqueidentifier;
select top 1
@SOURCECODEID = [ID]
from dbo.[MKTSOURCECODE]
where dbo.[UFN_SITEALLOWEDFORUSERONFEATURE](@CURRENTAPPUSERID, [MKTSOURCECODE].[SITEID], @SECURITYFEATUREID, @SECURITYFEATURETYPE) = 1
and [ISDEFAULT] <> 0 and [ISACTIVE] <> 0
and not exists(select top 1 1 from dbo.[MKTSOURCECODEITEM] as [I] inner join dbo.[MKTSOURCECODEPARTDEFINITION] as [PD] on [PD].[ID] = [I].[MKTSOURCECODEPARTDEFINITIONID] where [I].[SOURCECODEID] = [MKTSOURCECODE].[ID] and [PD].[ITEMTYPECODE] = 6)
and not exists(select top 1 1 from dbo.[MKTSOURCECODEITEM] as [I] inner join dbo.[MKTSOURCECODEPARTDEFINITION] as [PD] on [PD].[ID] = [I].[MKTSOURCECODEPARTDEFINITIONID] where [I].[SOURCECODEID] = [MKTSOURCECODE].[ID] and [PD].[ITEMTYPECODE] = 7)
-- do not display empty source code layouts
and exists (select top 1 1 from dbo.[MKTSOURCECODEITEM] where [MKTSOURCECODEITEM].[SOURCECODEID] = [MKTSOURCECODE].[ID]);
return @SOURCECODEID;
end