USP_DATALIST_MKTSEGMENTMEDIAOUTLETS

Displays a list of all media outlets.

Parameters

Parameter	Parameter Type	Mode	Description
@GROUPID	uniqueidentifier	IN	Group
@SEGMENTCATEGORYCODEID	uniqueidentifier	IN	Category
@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_MKTSEGMENTMEDIAOUTLETS]
(
  @GROUPID uniqueidentifier = null,
  @SEGMENTCATEGORYCODEID uniqueidentifier = null,
  @SITEFILTERMODE tinyint = 0,
  @SITESSELECTED xml = null,
  @SECURITYFEATUREID uniqueidentifier = null,
  @SECURITYFEATURETYPE tinyint = null,
  @CURRENTAPPUSERID uniqueidentifier = null
)
as
  set nocount on;

  select
    [ID],
    [NAME],
    [GROUPID],
    [GROUP],
    [CATEGORY],
    [CODE],
    [VENDOR],
    [IMPRESSIONS],
    [IMPRESSIONCALCULATIONMETHOD],
    [INUSE],
    [ISACTIVE],
    [SITE],
    [DESCRIPTION]
  from dbo.[UFN_MKTSEGMENTPASSIVE_GETDATALIST](6, @GROUPID, @SEGMENTCATEGORYCODEID, null) as [MKTSEGMENT]
  where (dbo.UFN_APPUSER_ISSYSADMIN(@CURRENTAPPUSERID) = 1 or exists (select 1 from dbo.UFN_SITESFORUSERONFEATURE(@CURRENTAPPUSERID,@SECURITYFEATUREID,@SECURITYFEATURETYPE) where SITEID=[MKTSEGMENT].[SITEID] or (SITEID is null and [MKTSEGMENT].[SITEID] is null)))
  and (@SITEFILTERMODE = 0 or [MKTSEGMENT].[SITEID] in (select [SITEID] from dbo.[UFN_SITE_BUILDDATALISTSITEFILTER](@CURRENTAPPUSERID, @SITEFILTERMODE, @SITESSELECTED)))
  order by [GROUP], [SEQUENCE], [NAME];

  return 0;