USP_DATALIST_WORKFLOW_SYSTEM_LOG

Returns all Workflow Log records across all workflow instances as well as non-instance messages.

Parameters

Parameter	Parameter Type	Mode	Description
@STARTDATE	date	IN	Start date
@ENDDATE	date	IN	End date
@MAXRECORDS	int	IN	Log records to show
@INCLUDEINFORMATIONMESSAGES	bit	IN	Include information messages
@ALERTSTARTDATE	date	IN	Alert start date
@ALERTENDDATE	date	IN	Alert end date

Definition

Copy



CREATE procedure dbo.USP_DATALIST_WORKFLOW_SYSTEM_LOG

@STARTDATE date = null,
@ENDDATE date = null,
@MAXRECORDS int = 100,
@INCLUDEINFORMATIONMESSAGES bit=0,

@ALERTSTARTDATE date = null,
@ALERTENDDATE date = null

as
    set nocount on;

  if @ALERTSTARTDATE is not null set @STARTDATE=@ALERTSTARTDATE;
  if @ALERTENDDATE is not null set @ENDDATE=@ALERTENDDATE;

  if @MAXRECORDS is null set @MAXRECORDS=100;

    select TOP(@MAXRECORDS)

        BBWORKFLOWLOG.[ID],


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


        BBWORKFLOWLOG.[LOGMESSAGE],

        BBWORKFLOWLOG.[LOGDATE],

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

        COALESCE(INFO.LOOKUPID,'') AS LOOKUPID,
        INFO.ID as BBWORKFLOWINSTANCEINFOID,

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

        BBWORKFLOWLOG.DATEADDED

    from 
        dbo.BBWORKFLOWLOG
        left outer join dbo.BBWORKFLOWINSTANCEINFO as INFO ON BBWORKFLOWLOG.BBWORKFLOWINSTANCEINFOID=INFO.ID

where 

(
  (
  (@STARTDATE IS NULL) OR ([LOGDATE] >= @STARTDATE)
  )
AND
  (
  (@ENDDATE IS NULL) OR ([LOGDATE] <= @ENDDATE)
  )
)

AND

(

  (BBWORKFLOWLOG.[LOGTYPECODE] <> 0) OR (@INCLUDEINFORMATIONMESSAGES = 1)

)

ORDER BY BBWORKFLOWLOG.DATEADDED DESC, BBWORKFLOWLOG.LOGDATE DESC, BBWORKFLOWLOG.SOURCECODE DESC;