USP_DATALIST_WORKFLOW_LOG

Returns all Workflow Log records for the given workflowinstance.

Parameters

Parameter	Parameter Type	Mode	Description
@BBWORKFLOWINSTANCEINFOID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.
@STARTDATE	datetimeoffset	IN	Start date
@ENDDATE	datetimeoffset	IN	End date
@LOGTYPECODE	tinyint	IN

Definition

Copy



CREATE procedure dbo.USP_DATALIST_WORKFLOW_LOG

@BBWORKFLOWINSTANCEINFOID uniqueidentifier,

@STARTDATE datetimeoffset = null,
@ENDDATE datetimeoffset = null,
@LOGTYPECODE tinyint = null

as
    set nocount on;

    select 
        BBWORKFLOWLOG.[ID],


        BBWORKFLOWLOG.[SOURCECODE],
        BBWORKFLOWLOG.[SOURCE],


        BBWORKFLOWLOG.[LOGMESSAGE],

        BBWORKFLOWLOG.[LOGDATE],

        BBWORKFLOWLOG.[LOGTYPECODE],
        BBWORKFLOWLOG.[LOGTYPE],

        ROW_NUMBER() OVER(ORDER BY DATEADDED ASC, LOGDATE ASC) AS LOGSEQUENCE

    from 
        dbo.BBWORKFLOWLOG

where 
BBWORKFLOWLOG.BBWORKFLOWINSTANCEINFOID = @BBWORKFLOWINSTANCEINFOID
AND
(
  (
  (@STARTDATE IS NULL) OR ([LOGDATE] >= @STARTDATE)
  )
AND
  (
  (@ENDDATE IS NULL) OR ([LOGDATE] <= @ENDDATE)
  )
AND
  (
  @LOGTYPECODE IS NULL or LOGTYPECODE = @LOGTYPECODE
  )  
)
ORDER BY DATEADDED ASC, LOGDATE ASC, SOURCECODE;