spMFUnDeleteObject

Signature

EXEC dbo.spMFUnDeleteObject
    @MFtableName = N'MFCustomer',
    @ObjID = 1,
    @RetainDeletions = 0,
    @Output = NULL OUTPUT,
    @Update_ID = NULL OUTPUT,
    @ProcessBatch_ID = NULL OUTPUT,
    @Debug = 0;

Returns

INT: 1 = success (undeleted); 2 = failed (object not found); -1 = SQL error.

Parameters

@MFtableName

• Type: NVARCHAR(128)

• Required: Yes

• Description: Class table name.

@ObjID

• Type: INT

• Required: Yes

• Description: ObjID to undelete.

@RetainDeletions

• Type: BIT

• Required: No (default = 0)

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

@Output

• Type: NVARCHAR(2000)

• Required: No (OUTPUT)

• Description: Output message.

@Update_ID

• Type: INT

• Required: No (OUTPUT)

• Description: ID in MFUpdateHistory.

@ProcessBatch_ID

• Type: INT

• Required: No (OUTPUT)

• Description: ID in MFProcessBatch.

@Debug

• Type: SMALLINT

• Required: No (default = 0)

• Description: Debug level.

Purpose

An object can be undeleted from M-Files using the ClassTable by using the spMFUnDeleteObject procedure. Is it optional to undelete the object in M-Files.

Warnings

To undelete an object the object must be deleted.

Examples

 DECLARE @Output NVARCHAR(2000),
 @ProcessBatch_ID INT;
 EXEC dbo.spMFUnDeleteObject @ObjectTypeId = 0,
                       @objectId = 139
                       @Output = @Output OUTPUT,
                       @ProcessBatch_ID = @ProcessBatch_ID OUTPUT,
                       @Debug = 1

                       SELECT @output

SELECT @rt, @update_ID, @ProcessBatch_ID1
SELECT * FROM dbo.MFUpdateHistory AS muh WHERE id = @update_ID
SELECT * FROM dbo.MFProcessBatch AS mpb WHERE mpb.ProcessBatch_ID = @ProcessBatch_ID1
SELECT * FROM dbo.MFProcessBatchDetail AS mpb WHERE mpb.ProcessBatch_ID = @ProcessBatch_ID1

Changelog

Date	Author	Description
2022-02-09	LC	Create new procedure and assembly method