spMFInsertWorkflowState

Signature

EXEC dbo.spMFInsertWorkflowState
    @Doc = N'<xml>',
    @Output = NULL OUTPUT,
    @Debug = 0;

Returns

INT: 1 on success; -1 on error.

Parameters

@Doc

  • Type: NVARCHAR(MAX)

  • Required: Yes

  • Description: Workflow state data (XML).

@Output

  • Type: INT

  • Required: No (OUTPUT)

  • Description: Status or count output value.

@Debug

  • Type: SMALLINT

  • Required: No (default = 0)

  • Description: Debug level. - 1 = Standard Debug Mode - 101 = Advanced Debug Mode

Purpose

To insert Workflow State details into MFWorkflowState table.

This procedure is called by other procedures

Changelog

Date

Author

Description

2024-06-05

LC

add processbatch_id for logging

2023-07-29

LC

Improve logging and productivity

2019-08-30

JC

Added documentation

2019-03-08

DEV2

Add insert updatecolumn

2017-07-02

LC

Change aliase datatype to varchar(100); Edit TRANS loop