USP_DATALIST_EVENTINVITATIONHISTORY

This datalist displays the history of runs for an invitation used for an event.

Parameters

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

Definition

Copy



CREATE procedure dbo.USP_DATALIST_EVENTINVITATIONHISTORY
(
  @INVITATIONID uniqueidentifier
)
as
  set nocount on;

  select
    INVITATIONHISTORY.ID,
    INVITATIONHISTORY.BUSINESSPROCESSSTATUSID,
    case
      when
      (
        INVITATIONHISTORY.PARAMETERSETID is null
        or
        len(INVITATIONHISTORY.PARAMETERSETID) = 0
      )
      then
        STANDARDVALUES.ID
      else
        cast(INVITATIONHISTORY.PARAMETERSETID as uniqueidentifier)
    end [PARAMETERSETID],
    STANDARDVALUES.EnableDownload,
    case
      when INVITATIONHISTORY.NAME = '' then
        'Process is starting...'
      else
        INVITATIONHISTORY.NAME
    end [NAME],
    STANDARDVALUES.StartedBy,
    STANDARDVALUES.STARTEDON,
    '116332AF-BB79-4608-9709-4203BD2BA318' as BUSINESSPROCESSCATALOGID,
    coalesce(INVITATIONHISTORY.SEGMENTATIONACTIVATEPROCESSSTATUSID, '00000000-0000-0000-0000-000000000000') as ACTIVATEPROCESSSTATUSID,
    STANDARDVALUES.Status,
    STANDARDVALUES.NumberOfRecordsProcessed,
    STANDARDVALUES.NumberOfRecordsProcessed
  from dbo.UFN_BUSINESSPROCESSSTATUS_STANDARDDATALISTVALUES('116332AF-BB79-4608-9709-4203BD2BA318', @INVITATIONID, null) as STANDARDVALUES
  inner join dbo.INVITATIONHISTORY on INVITATIONHISTORY.BUSINESSPROCESSSTATUSID = STANDARDVALUES.ID
  order by [STANDARDVALUES].StartedOn desc;

  return 0;