USP_DATALIST_WORKFLOW_INSTANCE_BUSINESSACTIVITIES

A list of the Business Activity records that exist for a given workflow instance.

Parameters

Parameter	Parameter Type	Mode	Description
@BBWORKFLOWINSTANCEINFOID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.
@INCLUDE_MEDIUM_LEVEL_DETAILS	bit	IN	Show mid-level details
@INCLUDE_LOW_LEVEL_DETAILS	bit	IN	Show low-level details

Definition

Copy



CREATE procedure dbo.USP_DATALIST_WORKFLOW_INSTANCE_BUSINESSACTIVITIES

    @BBWORKFLOWINSTANCEINFOID uniqueidentifier,
    @INCLUDE_MEDIUM_LEVEL_DETAILS bit = 0,
    @INCLUDE_LOW_LEVEL_DETAILS bit = 0

as

    set nocount on;

  declare @DONE_IMAGE_KEY nvarchar(100)= N'CATALOG:Blackbaud.AppFx.Workflow.Catalog,Blackbaud.AppFx.Workflow.Catalog.checkmark.png';


  declare @RUNNING_IMAGE_KEY nvarchar(100)= N'CATALOG:Blackbaud.AppFx.Workflow.Catalog,Blackbaud.AppFx.Workflow.Catalog.process.png';


    select 
    ID,
    DISPLAYNAME,
  case when ACTIVITYENDDATE IS NULL THEN 'In progress, Pending' ELSE 'Completed' end AS STATUS,
  CAST((case when ACTIVITYENDDATE IS NULL THEN 0 ELSE 1 end) AS BIT) AS COMPLETED,

  [DESCRIPTION],

    ACTIVITYSTARTDATE,
    ACTIVITYENDDATE,
    STARTMESSAGE,
    ENDMESSAGE,            
    case when ACTIVITYENDDATE IS NULL THEN STARTMESSAGE ELSE ENDMESSAGE end AS CURRENTSTATUSMESSAGE,
    DETAILLEVELCODE,
    DETAILLEVEL,
    DATEADDED,

  case when ACTIVITYENDDATE IS NULL THEN @RUNNING_IMAGE_KEY ELSE @DONE_IMAGE_KEY end AS IMAGEKEY

  ,PARENTBBWORKFLOWBUSINESSACTIVITYID

  ,ROW_NUMBER () OVER (order by DATEADDED,ACTIVITYSTARTDATE,ACTIVITYENDDATE) as SEQUENCE

    from dbo.BBWORKFLOWBUSINESSACTIVITY
    where BBWORKFLOWINSTANCEINFOID = @BBWORKFLOWINSTANCEINFOID

    AND
    (    
        (DETAILLEVELCODE=0)
    OR    (DETAILLEVELCODE=1 AND @INCLUDE_MEDIUM_LEVEL_DETAILS=1)
    OR    (DETAILLEVELCODE=2 AND @INCLUDE_LOW_LEVEL_DETAILS=1)
    )
    order by DATEADDED,ACTIVITYSTARTDATE, ACTIVITYENDDATE;