USP_DATALIST_MKTSEGMENTGROUPPASSIVE

Displays a list of all public media segment groups.

Parameters

Parameter	Parameter Type	Mode	Description
@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.
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.

Definition

Copy



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

  select 
    [MKTSEGMENTGROUP].[ID],
    [MKTSEGMENTGROUP].[NAME],
    (select count(*) from dbo.[MKTGROUPSEGMENTS] where [MKTGROUPSEGMENTS].[SEGMENTGROUPID] = [MKTSEGMENTGROUP].[ID]) as [SEGMENTS],
    convert(nvarchar(36), [MKTSEGMENTGROUP].[ID]) + '|2' as [IDFOREDIT],
    [SITE].[NAME] as [SITE],
    (select isnull(max([SEQUENCE]) + 1, 0) from dbo.[MKTGROUPSEGMENTS] where [MKTGROUPSEGMENTS].[SEGMENTGROUPID] = [MKTSEGMENTGROUP].[ID]) as [NEXTSEQUENCE]
  from dbo.[MKTSEGMENTGROUP]
  left outer join dbo.[SITE] on [SITE].[ID] = [MKTSEGMENTGROUP].[SITEID]
  where ([MKTSEGMENTGROUP].[SEGMENTFAMILYTYPECODE] = 2 or [MKTSEGMENTGROUP].[SEGMENTFAMILYTYPECODE] = 0)
  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)))
  and (@SITEFILTERMODE = 0 or [MKTSEGMENTGROUP].[SITEID] in (select [SITEID] from dbo.[UFN_SITE_BUILDDATALISTSITEFILTER](@CURRENTAPPUSERID, @SITEFILTERMODE, @SITESSELECTED)))
  order by [MKTSEGMENTGROUP].[NAME];

  return 0;