USP_SIMPLEDATALIST_MKTSEGMENTGROUP

Returns a list of available segment groups.

Parameters

Parameter	Parameter Type	Mode	Description
@SEGMENTFAMILYTYPECODE	tinyint	IN	Segment family type
@LISTID	uniqueidentifier	IN	List ID
@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_MKTSEGMENTGROUP]
(
  @SEGMENTFAMILYTYPECODE tinyint,
  @LISTID uniqueidentifier = null,
  @CURRENTAPPUSERID uniqueidentifier = null,
  @SECURITYFEATUREID uniqueidentifier = null,
  @SECURITYFEATURETYPE tinyint = null
)
as
  set nocount on;

  select distinct
    [MKTSEGMENTGROUP].[ID] as [VALUE],
    [MKTSEGMENTGROUP].[NAME] as [LABEL]
  from dbo.[MKTSEGMENTGROUP]
  left join dbo.[MKTGROUPSEGMENTS] on [MKTGROUPSEGMENTS].[SEGMENTGROUPID] = [MKTSEGMENTGROUP].[ID]
  left join dbo.[MKTSEGMENT] on [MKTSEGMENT].[ID] = [MKTGROUPSEGMENTS].[SEGMENTID]
  left join dbo.[MKTSEGMENTLIST] on [MKTSEGMENTLIST].[ID] = [MKTSEGMENT].[CURRENTSEGMENTLISTID]
  where ([MKTSEGMENTGROUP].[SEGMENTFAMILYTYPECODE] = @SEGMENTFAMILYTYPECODE or [MKTSEGMENTGROUP].[SEGMENTFAMILYTYPECODE] = 0)
  and (@LISTID is null or [MKTSEGMENTLIST].[LISTID] = @LISTID)
  and (dbo.UFN_APPUSER_ISSYSADMIN(@CURRENTAPPUSERID) = 1 or exists (select 1 from dbo.UFN_SITESFORUSERONFEATURE(@CURRENTAPPUSERID,@SECURITYFEATUREID,@SECURITYFEATURETYPE) where SITEID=[MKTSEGMENTGROUP].[SITEID] or (SITEID is null and [MKTSEGMENTGROUP].[SITEID] is null)))
  order by [MKTSEGMENTGROUP].[NAME];

  return 0;