spMFSynchronizeWorkFlowStateColumnChange

Signature

EXEC dbo.spMFSynchronizeWorkFlowStateColumnChange
    @TableName = N'MFCustomer',
    @ProcessBatch_ID = NULL OUTPUT,
    @Debug = 0;

Returns

INT: 1 on success; -1 on error.

Parameters

@TableName
  • Type: NVARCHAR(128)

  • Required: Yes

  • Description: Valid class table name (e.g., ‘MFCustomer’).

@ProcessBatch_ID
  • Type: INT

  • Required: No (OUTPUT)

  • Description: References the ID of the ProcessBatch logging table.

@Debug
  • Type: SMALLINT

  • Required: No (default = 0)

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

Purpose

The purpose of this procedure is to synchronize workflow state name change in M-Files into the reference table

Examples

EXEC dbo.spMFSynchronizeWorkFlowStateColumnChange @TableName = N'MFCustomer';

Changelog

Date

Author

Description

2020-03-27

LC

Add documentation

2019-06-10

LC

fix bug in name of procedure for error trapping

2018-03-01

DEV2

Create procedure