Create Lookup Views for Value Lists and Workflow States

This example demonstrates how to create convenience views for lookups, simplifying joins in code when resolving IDs.

Create Value List Lookup View

SELECT *
FROM MFValueListItems mvli
INNER JOIN MFValuelist mvl ON mvl.id = mvli.MFValueListID
WHERE mvl.Name = 'Country';

EXEC dbo.spMFCreateValueListLookupView @ValueListName = 'Country',
                              @ViewName = 'MFvwCountry',
                              @Schema = 'Custom';

SELECT * FROM custom.MFvwCountry;

Create Workflow State Lookup View

SELECT *
FROM MFWorkflow mwf
INNER JOIN MFWorkflowState mwfs ON mwf.ID = mwfs.MFWorkflowID;

EXEC dbo.spMFCreateWorkflowStateLookupView @WorkflowName = 'Contract Approval Workflow',
                                 @ViewName = 'MFvwContractApproval',
                                 @Schema = 'Custom';

SELECT * FROM custom.MFvwContractApproval;