USP_DATALIST_MKTMARKETINGPLANTASKS

Displays a list of the active marketing plan tasks for a given marketing plan item.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



CREATE procedure dbo.[USP_DATALIST_MKTMARKETINGPLANTASKS]
(
  @ID uniqueidentifier
)
as
  set nocount on;

  declare @USECONSTITUENTFOROWNER bit;
  set @USECONSTITUENTFOROWNER = (case when dbo.[UFN_INSTALLEDPRODUCTS_PRODUCTIS]('BB9873D7-F1ED-430A-8AB4-F09F47056538') = 0 then 1 else 0 end);

  select
    [MKTMARKETINGPLANITEMTASK].[ID],
    [MKTMARKETINGPLANITEMTASK].[DUEDATE] as [DUEDATE],
    [MKTMARKETINGPLANITEMTASK].[DATECOMPLETED] as [COMPLETED],
    case [MKTMARKETINGPLANITEMTASK].[MARKETINGPLANTASKSTATUSCODE]
      when 0 then 'Active'
      when 1 then 'Completed'
      else ''
    end as [STATUS],
    [MKTMARKETINGPLANITEMTASK].[SUBJECT],
    case when dbo.[UFN_INSTALLEDPRODUCTS_PRODUCTIS]('BB9873D7-F1ED-430A-8AB4-F09F47056538') = 0
      then [CONSTITUENT].[NAME]
      else [MKTMARKETINGPLANITEMTASK].[OWNER]
    end as [OWNER],
    [MKTMARKETINGPLANITEMTASK].[NOTES]
  from dbo.[MKTMARKETINGPLANITEMTASK]
  inner join dbo.[MKTMARKETINGPLANITEM] on [MKTMARKETINGPLANITEM].[ID] = [MKTMARKETINGPLANITEMTASK].[MARKETINGPLANITEMID]
  inner join dbo.[MKTMARKETINGPLAN] on [MKTMARKETINGPLAN].[ID] = [MKTMARKETINGPLANITEM].[MARKETINGPLANID]
  left outer join dbo.[CONSTITUENT] on [MKTMARKETINGPLANITEMTASK].[OWNERID] = [CONSTITUENT].[ID]
  where [MKTMARKETINGPLANITEMTASK].[MARKETINGPLANITEMID] = @ID
  order by [MKTMARKETINGPLANITEMTASK].[DUEDATE], [MKTMARKETINGPLANITEMTASK].[SUBJECT];

  return 0;