spMFUpdateTable_ObjIDs_Grouped

Signature

EXEC dbo.spMFUpdateTable_ObjIDs_Grouped
    @MFTableName = N'MFCustomer',
    @MFTableSchema = N'dbo',
    @UpdateMethod = 1,
    @ProcessId = 6,
    @UserId = NULL,
    @RetainDeletions = 0,
    @IsDocumentCollection = 0,
    @ProcessBatch_ID = NULL OUTPUT,
    @Debug = 0;

Returns

INT: 1 on success; -1 on error.

Parameters

@MFTableName

• Type: NVARCHAR(128)

• Required: Yes

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

@MFTableSchema

• Type: NVARCHAR(128)

• Required: No (default = ‘dbo’)

• Description: Schema to operate on.

@UpdateMethod

• Type: INT

• Required: No (default = 1)

• Description: 1 = M-Files to MFSQL; 0 = MFSQL to M-Files.

@ProcessId

• Type: INT

• Required: No (default = 6)

• Description: Process identifier (e.g., 6 = merged updates).

@UserId

• Type: NVARCHAR(200)

• Required: No (default = NULL)

• Description: Limit update to a specific user.

@RetainDeletions

• Type: BIT

• Required: No (default = 0)

• Description: Set to 1 to retain deletions in class table.

@IsDocumentCollection

• Type: BIT

• Required: No (default = 0)

• Description: Set to 1 if the class table refers to a document collection.

@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 - 101 = Advanced Debug Mode

Purpose

The purpose of this procedure is to group source records into batches and compile a list of OBJIDs in CSV format to pass to spMFUpdateTable

Examples

EXEC [spMFUpdateTable_ObjIDs_Grouped]
     @MFTableName = 'CLGLChart',
     @MFTableSchema = 'dbo',
     @UpdateMethod = 0
     @ProcessId = 6     , -- 6 Merged Updates
     @UserId = NULL, --null for all user update
     @Debug  = 1

Changelog

Date	Author	Description
2022-09-02	LC	Update to include RetainDeletions and DocumentCollections
2019-08-30	JC	Added documentation
2017-06-29	AC	@ObjIds_toUpdate change sizes to NVARCHAR(4000)
2017-06-29	AC	@ObjIds_FieldLenth change default value to 2000