spMFGetObjectvers

Signature

EXEC dbo.spMFGetObjectvers
    @TableName = N'MFLarge_Volume',
    @dtModifiedDate = '1985-01-01',
    @MFIDs = NULL,
    @outPutXML = NULL OUTPUT,
    @ProcessBatch_ID = NULL OUTPUT,
    @Debug = 0;

Returns

INT: 1 on success; -1 on error.

Parameters

@TableName

  • Type: NVARCHAR(100)

  • Required: Yes

  • Description: Class table name.

@dtModifiedDate

  • Type: DATETIME

  • Required: No (default = ‘1985-01-01’)

  • Description: Starting date for object versions and deletions.

@MFIDs

  • Type: NVARCHAR(4000)

  • Required: No (default = NULL)

  • Description: Comma-delimited string of ObjIDs; when provided, date is ignored.

@outPutXML

  • Type: NVARCHAR(MAX)

  • Required: No (OUTPUT)

  • Description: Returns object versions of filtered objects (as XML).

@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

To get all the object versions of the class table as XML.

Deleted objects and current objects are combined in the @OutputXML if MFIDs are used as a parameter When the MFID parameter is used, the date is ignored. When Last modified date are used then the @outputXML will include the objects changed later than the date specified and the @DeletedOutputXML will include the objects that was deleted since the date lastmodified date.

Examples

DECLARE @outPutXML    NVARCHAR(MAX),
@DeletedoutPutXML    NVARCHAR(MAX),
@ProcessBatch_ID3 INT;

EXEC dbo.spMFGetObjectvers @TableName = MFLarge_volume,
@dtModifiedDate = '2020-08-01',
@MFIDs = null,
@outPutXML = @outPutXML OUTPUT,
@ProcessBatch_ID = @ProcessBatch_ID3 OUTPUT,
@Debug = 101

SELECT CAST(@outPutXML AS XML)

Changelog

Date

Author

Description

2021-12-21

LC

This procedure is no longer used by MFTableAudit

2021-12-20

LC

Pair connection test with wrapper

2020-08-25

LC

Add return XML for deleted records

2019-12-12

LC

Improve text in MFProcessBatchDetail

2019-09-04

LC

Add connection test

2019-08-30

JC

Added documentation

2019-08-05

LC

Improve logging

2019-07-10

LC

Add debugging and messaging

2018-04-04

DEV2

Added License module validation code

2016-08-22

LC

Update settings index

2016 08-22

LC

Change objids to NVARCHAR(4000)

2015 09-21

DEV2

Removed old style vaultsettings, replace with @VaultSettings

2015-06-16

Kishore

Create procedure