Get Deleted Objects

This example demonstrates fetching deleted objects and optionally removing them from SQL.

Update Items with Auto Delete

EXEC dbo.spMFUpdateTable @MFTableName = 'MFCustomer', @UpdateMethod = 1, @RetainDeletions = 1;

SELECT deleted, * FROM dbo.MFCustomer AS ma;

Update Deleted Items in Class Table

SELECT * FROM mfCustomer WHERE deleted = 1;

Fetch Deleted Objects

DECLARE @ProcessBatch_ID INT;
EXEC dbo.spMFGetDeletedObjects @MFTableName = 'MFCustomer',
                        @LastModifiedDate = NULL,
                        @ProcessBatch_ID = @ProcessBatch_ID OUTPUT,
                        @RemoveDeleted = 1,
                        @Debug = 0;

Get Deleted Items from Class

SELECT * FROM dbo.MFClass AS mc;

Fetch Deleted Objects Internally

DECLARE @outputXML NVARCHAR(MAX);
DECLARE @VaultSettings NVARCHAR(200) = dbo.FnMFVaultSettings();
EXEC dbo.spMFGetDeletedObjectsInternal @VaultSettings = @VaultSettings,
                             @ClassID = 78,
                             @LastModifiedDate = NULL,
                             @outputXML = @outputXML OUTPUT;
SELECT CAST(@outputXML AS xml);