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;