USP_DATALIST_MKTACKNOWLEDGEMENTMAILINGTEMPLATE

Displays a list of all marketing acknowledgement templates.

Parameters

Parameter	Parameter Type	Mode	Description
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@SITEFILTERMODE	tinyint	IN	Sites
@SITESSELECTED	xml	IN	Sites selected
@SECURITYFEATUREID	uniqueidentifier	IN	Input parameter indicating the ID of the feature to use for site security checking.
@SECURITYFEATURETYPE	tinyint	IN	Input parameter indicating the type of the feature to use for site security checking.

Definition

Copy



CREATE procedure dbo.[USP_DATALIST_MKTACKNOWLEDGEMENTMAILINGTEMPLATE]
(
  @CURRENTAPPUSERID uniqueidentifier = null,
  @SITEFILTERMODE tinyint = 0,
  @SITESSELECTED xml = null,
  @SECURITYFEATUREID uniqueidentifier = null,
  @SECURITYFEATURETYPE tinyint = null    
)
as
  set nocount on;

  select
    [MKTACKNOWLEDGEMENTMAILINGTEMPLATE].[ID],
    [MKTACKNOWLEDGEMENTMAILINGTEMPLATE].[NAME],
    [MKTACKNOWLEDGEMENTMAILINGTEMPLATE].[CODE],
    [MKTACKNOWLEDGEMENTMAILINGTEMPLATE].[DESCRIPTION],
    dbo.UFN_TRANSLATIONFUNCTION_SITE_GETNAME([MKTACKNOWLEDGEMENTMAILINGTEMPLATE].[SITEID]) as [SITE],
    [MKTACKNOWLEDGEMENTMAILINGPROCESS].[ID] as [ACKNOWLEDGEMENTMAILINGPROCESSID],
    (select count([ID]) from dbo.[MKTACKNOWLEDGEMENTMAILINGTEMPLATERULE] where [MKTACKNOWLEDGEMENTMAILINGTEMPLATERULE].[ACKNOWLEDGEMENTMAILINGTEMPLATEID] = [MKTACKNOWLEDGEMENTMAILINGTEMPLATE].[ID]) as [NUMRULES]
  from dbo.[MKTACKNOWLEDGEMENTMAILINGTEMPLATE]
  left outer join dbo.[MKTACKNOWLEDGEMENTMAILINGPROCESS] on [MKTACKNOWLEDGEMENTMAILINGPROCESS].[ACKNOWLEDGEMENTMAILINGTEMPLATEID] = [MKTACKNOWLEDGEMENTMAILINGTEMPLATE].[ID]
  where (dbo.UFN_APPUSER_ISSYSADMIN(@CURRENTAPPUSERID) = 1 or exists (select 1 from dbo.UFN_SITESFORUSERONFEATURE(@CURRENTAPPUSERID,@SECURITYFEATUREID,@SECURITYFEATURETYPE) where SITEID=[MKTACKNOWLEDGEMENTMAILINGTEMPLATE].[SITEID] or (SITEID is null and [MKTACKNOWLEDGEMENTMAILINGTEMPLATE].[SITEID] is null)))
  and (@SITEFILTERMODE = 0 or [MKTACKNOWLEDGEMENTMAILINGTEMPLATE].[SITEID] in (select [SITEID] from dbo.[UFN_SITE_BUILDDATALISTSITEFILTER](@CURRENTAPPUSERID, @SITEFILTERMODE, @SITESSELECTED)))
  and [MKTACKNOWLEDGEMENTMAILINGTEMPLATE].[ISSYSTEM] = 0 
  order by [MKTACKNOWLEDGEMENTMAILINGTEMPLATE].[NAME];

  return 0;