USP_DATALIST_MKTSEGMENTATIONEXPORTPROCESS

A datalist of saved marketing effort export process parameter sets.

Parameters

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

Definition

Copy



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

  select 
    [MKTSEGMENTATIONEXPORTPROCESS].[ID],
    [MKTSEGMENTATION].[ID] as [SEGMENTATIONID],
    [MKTSEGMENTATION].[NAME],
    dbo.[UFN_TRANSLATIONFUNCTION_SITE_GETNAME]([MKTSEGMENTATION].[SITEID]) as [SITE],
    (select max([STARTEDON]) 
       from dbo.[BUSINESSPROCESSSTATUS]
      inner join dbo.[MKTSEGMENTATIONEXPORTPROCESSSTATUS] on [MKTSEGMENTATIONEXPORTPROCESSSTATUS].[ID] = [BUSINESSPROCESSSTATUS].[ID]
      where [BUSINESSPROCESSSTATUS].[STATUSCODE] = 0
        and [MKTSEGMENTATIONEXPORTPROCESSSTATUS].[PARAMETERSETID] = [MKTSEGMENTATIONEXPORTPROCESS].[ID]) as [LASTRUN],
    [MKTSEGMENTATIONEXPORTPROCESS].[DESCRIPTION],
    convert(bit, case when [MKTSEGMENTATION].[ACTIVE] = 1 or 
                           ((select isnull(count([ID]), 0) from dbo.[MKTSEGMENTATIONSEGMENT] where [SEGMENTATIONID] = [MKTSEGMENTATIONEXPORTPROCESS].[SEGMENTATIONID]) > 0 and 
                            dbo.[UFN_MKTSEGMENTATION_ISRECORDCOUNTCACHECURRENT]([MKTSEGMENTATIONEXPORTPROCESS].[SEGMENTATIONID], 0) = 1 and
                            dbo.[UFN_MKTSEGMENTATION_ISCALCULATING]([MKTSEGMENTATIONEXPORTPROCESS].[SEGMENTATIONID]) = 0 and
                            dbo.[UFN_MKTSEGMENTATION_ISACTIVATING]([MKTSEGMENTATIONEXPORTPROCESS].[SEGMENTATIONID]) = 0)
                      then 1 else 0 end) as [RUNNABLE]
  from dbo.[MKTSEGMENTATIONEXPORTPROCESS]
  inner join dbo.[MKTSEGMENTATION] on [MKTSEGMENTATION].[ID] = [MKTSEGMENTATIONEXPORTPROCESS].[SEGMENTATIONID]
  where [MKTSEGMENTATION].[MAILINGTYPECODE] = 0
  and [MKTSEGMENTATION].[COMMUNICATIONTYPECODE] = 0 -- no BBEC appeal mailings

  and [MKTSEGMENTATION].[ISHISTORICAL] = 0
  and (dbo.UFN_APPUSER_ISSYSADMIN(@CURRENTAPPUSERID) = 1 or exists (select 1 from dbo.UFN_SITESFORUSERONFEATURE(@CURRENTAPPUSERID,@SECURITYFEATUREID,@SECURITYFEATURETYPE) where SITEID=[MKTSEGMENTATION].[SITEID] or (SITEID is null and [MKTSEGMENTATION].[SITEID] is null)))
  order by [MKTSEGMENTATION].[NAME];

  return 0;