Updating Value List Items

This example demonstrates how to synchronize and edit value list items, create a lookup view, and propagate changes.

Synchronize Value List Items

TRUNCATE TABLE dbo.MFValueListItems;
SELECT * FROM dbo.MFValueListItems;
EXEC dbo.spMFSynchronizeSpecificMetadata @Metadata = 'ValuelistItems';
--or
EXEC dbo.spMFSynchronizeSpecificMetadata @Metadata = 'ValuelistItem', @ItemName = 'Country';

Create Value List Lookup View

EXEC dbo.spMFCreateValueListLookupView @ValueListName = N'Country',
                                                                           @ViewName = N'vwCountry',
                                                                           @Schema = N'custom',
                                                                           @Debug = 0;
SELECT * FROM custom.vwCountry;

Change Name of Value List Item

UPDATE mvli
SET Process_ID = 1,
        Name = 'UK',
        DisplayID = '3'
FROM MFValuelistitems mvli
WHERE mvli.AppRef = '2#154#3';

Insert New Value List Item

DECLARE @Valuelist_ID INT;
SELECT @Valuelist_ID = id FROM dbo.MFValueList WHERE name = 'Country';
INSERT INTO MFValueListItems (Name, Process_ID, DisplayID, MFValueListID)
VALUES ('Russia', 1, 'RU', @Valuelist_ID);
INSERT INTO MFValueListItems (Name, Process_ID, MFValueListID)
VALUES ('Argentina', 1, @Valuelist_ID);

Delete Value List Item

SELECT * FROM custom.vwCountry;
UPDATE mvli
SET Process_ID = 2
FROM MFValuelistitems mvli
WHERE mvli.AppRef = '2#154#9';

Process Update

EXEC spMFSynchronizeValueListItemsToMFiles;
SELECT * FROM custom.vwCountry;

Check Entry in MFValueListItems

SELECT * FROM dbo.MFValueListItems AS mvli WHERE mvli.AppRef = '2#154#3';

Check Class Table with Related Value List Item Before Sync

SELECT * FROM dbo.MFCustomer AS mc;

Synchronize Lookup Column Change

DECLARE @ProcessBatch_id1 INT;
EXEC dbo.spmfSynchronizeLookupColumnChange @TableName = NULL,
                                                                                   @ProcessBatch_id = @ProcessBatch_id1 OUTPUT,
                                                                                   @Debug = 0;