USP_SIMPLEDATALIST_MKTLISTLAYOUT

Returns a list of all list layouts

Parameters

Parameter	Parameter Type	Mode	Description
@RECORDSOURCEID	uniqueidentifier	IN	Record Source ID
@TYPECODE	tinyint	IN	Type code
@SECURITYFEATUREID	uniqueidentifier	IN
@SECURITYFEATURETYPE	tinyint	IN
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.

Definition

Copy



CREATE procedure dbo.[USP_SIMPLEDATALIST_MKTLISTLAYOUT]
(
  @RECORDSOURCEID uniqueidentifier = null,
  @TYPECODE tinyint = null,
  @SECURITYFEATUREID uniqueidentifier = null,
  @SECURITYFEATURETYPE tinyint = null,
  @CURRENTAPPUSERID uniqueidentifier = null
)
as
  set nocount on;

  select
    [MKTLISTLAYOUT].[ID] as [VALUE],
    [MKTLISTLAYOUT].[NAME] as [LABEL]
  from dbo.[MKTLISTLAYOUT]
  where (@RECORDSOURCEID is null or @RECORDSOURCEID=[MKTLISTLAYOUT].[RECORDSOURCEID])
  and (@TYPECODE is null or @TYPECODE=[MKTLISTLAYOUT].[TYPECODE])
  and (dbo.UFN_APPUSER_ISSYSADMIN(@CURRENTAPPUSERID) = 1 or exists (select 1 from dbo.UFN_SITESFORUSERONFEATURE(@CURRENTAPPUSERID,@SECURITYFEATUREID,@SECURITYFEATURETYPE) where SITEID=[MKTLISTLAYOUT].[SITEID] or (SITEID is null and [MKTLISTLAYOUT].[SITEID] is null)))
  order by [MKTLISTLAYOUT].[NAME];

  return 0;