USP_DATALIST_INVITATIONPROCESSSTATUS

This datalist displays a status list for the invitation business process.

Parameters

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

Definition

Copy



CREATE procedure dbo.USP_DATALIST_INVITATIONPROCESSSTATUS
(
  @PARAMETERSETID uniqueidentifier,
  @STATUSCODE tinyint = null
)
as
  set nocount on;

  select 
    STANDARDVALUES.ID,
    STANDARDVALUES.ProcessName,
    STANDARDVALUES.Status,
    STANDARDVALUES.StatusMessage,
    [EVENT].[NAME] as [EVENTNAME],
    STANDARDVALUES.StartedBy,
    STANDARDVALUES.StartedOn,
    STANDARDVALUES.EndedOn,
    STANDARDVALUES.Duration,
    STANDARDVALUES.NumberOfRecordsProcessed,
    STANDARDVALUES.NumberOfExceptionRecords,
    STANDARDVALUES.TotalCount,
    STANDARDVALUES.ServerName,
    STANDARDVALUES.ImageKey,
    STANDARDVALUES.Completed,
    STANDARDVALUES.EnableDownload,
    STANDARDVALUES.EnableLetterMailMerge,
    STANDARDVALUES.EnableLabelMailMerge,
    '116332AF-BB79-4608-9709-4203BD2BA318' as BUSINESSPROCESSCATALOGID,
    @PARAMETERSETID as PARAMETERSETID,
    coalesce(INVITATIONHISTORY.SEGMENTATIONACTIVATEPROCESSSTATUSID, '00000000-0000-0000-0000-000000000000') as ACTIVATEPROCESSSTATUSID,
    STANDARDVALUES.NumberOfRecordsProcessed
  from dbo.UFN_BUSINESSPROCESSSTATUS_STANDARDDATALISTVALUES('116332AF-BB79-4608-9709-4203BD2BA318', @PARAMETERSETID, @STATUSCODE) as STANDARDVALUES
  inner join dbo.INVITATIONHISTORY on INVITATIONHISTORY.BUSINESSPROCESSSTATUSID = STANDARDVALUES.ID
  left join dbo.[EVENT] on [EVENT].[ID] = [INVITATIONHISTORY].[EVENTID]
  order by [STANDARDVALUES].StartedOn desc;

  return 0;