USP_SIMPLEDATALIST_MKTLETTERCODE

Returns a list of letters.

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_MKTLETTERCODE]
(
  @CURRENTAPPUSERID uniqueidentifier = null,
  @SECURITYFEATUREID uniqueidentifier = null,
  @SECURITYFEATURETYPE tinyint = null
)
as
  set nocount on;

  select distinct
    [LETTERCODE].[ID] as [VALUE],
    [LETTERCODE].[NAME] as [LABEL]
  from dbo.[LETTERCODE]
  inner join dbo.[EXPORTDEFINITION] on [EXPORTDEFINITION].[ID] = [LETTERCODE].[EXPORTDEFINITIONID]
  left join dbo.[LETTERCODESITE] on [LETTERCODE].[ID] = [LETTERCODESITE].[LETTERCODEID]
  where 
    [LETTERCODE].[ISACTIVE] = 1
    and dbo.[UFN_MKTEXPORTDEFINITION_RECORDTYPEIDISVALIDFORMARKETING]([EXPORTDEFINITION].[RECORDTYPEID]) = 1
    and (dbo.UFN_APPUSER_ISSYSADMIN(@CURRENTAPPUSERID) = 1 or exists (select 1 from dbo.UFN_SITESFORUSERONFEATURE(@CURRENTAPPUSERID,@SECURITYFEATUREID,@SECURITYFEATURETYPE) where SITEID=[LETTERCODESITE].[SITEID] or (SITEID is null and [LETTERCODESITE].[SITEID] is null)))
  order by [LETTERCODE].[NAME];

  return 0;