USP_SIMPLEDATALIST_MARKETINGPLANTEMPLATES
Displays a list of the available marketing plan templates.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @CURRENTAPPUSERID | uniqueidentifier | IN | Input parameter indicating the ID of the current user. |
| @SECURITYFEATUREID | uniqueidentifier | IN | |
| @SECURITYFEATURETYPE | tinyint | IN |
Definition
Copy
create procedure dbo.[USP_SIMPLEDATALIST_MARKETINGPLANTEMPLATES]
(
@CURRENTAPPUSERID uniqueidentifier = null,
@SECURITYFEATUREID uniqueidentifier = null,
@SECURITYFEATURETYPE tinyint = null
) as
set nocount on;
select
[ID] as [VALUE],
[NAME] as [LABEL]
from dbo.[MKTMARKETINGPLANTEMPLATE]
where (dbo.UFN_APPUSER_ISSYSADMIN(@CURRENTAPPUSERID) = 1 or exists (select 1 from dbo.UFN_SITESFORUSERONFEATURE(@CURRENTAPPUSERID,@SECURITYFEATUREID,@SECURITYFEATURETYPE) where SITEID=[MKTMARKETINGPLANTEMPLATE].[SITEID] or (SITEID is null and [MKTMARKETINGPLANTEMPLATE].[SITEID] is null)))
order by [NAME];