spMFGetDeletedObjects¶

Signature¶

EXEC dbo.spMFGetDeletedObjects
    @MFTableName = N'MFCustomer',
    @LastModifiedDate = '2000-01-01',
    @RemoveDeleted = 1,
    @ProcessBatch_ID = NULL OUTPUT,
    @Debug = 0;

Returns¶

INT: 1 on success; -1 on error.

Parameters¶

@MFTableName

Type: NVARCHAR(200)
Required: Yes
Description: Valid class table name (e.g., ‘MFCustomer’).

@LastModifiedDate

Type: DATETIME
Required: No (default = ‘2000-01-01’)
Description: Lower bound for searching deleted objects.

@RemoveDeleted

Type: BIT
Required: No (default = 1)
Description: When 1, remove deleted records from the class table; when 0, mark them in the ‘Deleted’ column instead.

@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¶

Identify and optionally remove deleted objects in M-Files in class table.

Note this procedure is now redundant and replace with the improvements to spmfUpdateTable and including the Deleted property 27 in the dataset from M-Files by default.

Changelog¶

Date	Author	Description
2020-08-22	LC	Remove procedure
2019-07-04	LC	Create Procedure
2019-08-30	JC	Added documentation
2019-09-03	LC	Set LastModifiedDate default to 2000-01-01
2019-09-03	LC	Fix bug related to vaultsettings parameter