USP_SIMPLEDATALIST_MKTSEGMENTATIONSEGMENTCALCULATEPROCESSSTATUS_PROCESSEDDATES

Returns a simple list of processed dates for a marketing effort segment record count calculation process.

Parameters

Parameter	Parameter Type	Mode	Description
@SEGMENTATIONID	uniqueidentifier	IN
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@TABLEKEY	nvarchar(100)	IN
@SECURITYFEATUREID	uniqueidentifier	IN
@SECURITYFEATURETYPE	tinyint	IN

Definition

Copy



CREATE procedure dbo.[USP_SIMPLEDATALIST_MKTSEGMENTATIONSEGMENTCALCULATEPROCESSSTATUS_PROCESSEDDATES]
(
  @SEGMENTATIONID uniqueidentifier,
  @CURRENTAPPUSERID uniqueidentifier,
  @TABLEKEY nvarchar(100) = null,
  @SECURITYFEATUREID uniqueidentifier = null,
  @SECURITYFEATURETYPE tinyint = null
)
as
  set nocount on;

  select
    [BUSINESSPROCESSSTATUS].[ID] as [VALUE],
    [BUSINESSPROCESSSTATUS].[ENDEDON] as [LABEL]
  from dbo.[MKTSEGMENTATION]
  inner join dbo.[MKTSEGMENTATIONSEGMENTCALCULATEPROCESS] on [MKTSEGMENTATIONSEGMENTCALCULATEPROCESS].[SEGMENTATIONID] = [MKTSEGMENTATION].[ID]
  inner join dbo.[MKTSEGMENTATIONSEGMENTCALCULATEPROCESSSTATUS] on [MKTSEGMENTATIONSEGMENTCALCULATEPROCESSSTATUS].[PARAMETERSETID] = [MKTSEGMENTATIONSEGMENTCALCULATEPROCESS].[ID]
  inner join dbo.[BUSINESSPROCESSSTATUS] on [BUSINESSPROCESSSTATUS].[ID] = [MKTSEGMENTATIONSEGMENTCALCULATEPROCESSSTATUS].[ID]
  where [MKTSEGMENTATION].[ID] = @SEGMENTATIONID
  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)))
  and (isnull(@TABLEKEY, '') = '' or exists(select * from dbo.[BUSINESSPROCESSOUTPUT] where [BUSINESSPROCESSSTATUSID] = [BUSINESSPROCESSSTATUS].[ID] and [TABLEKEY] = @TABLEKEY))
  order by [BUSINESSPROCESSSTATUS].[ENDEDON] desc;

  return 0;