spMFCreateAllLookups¶
Signature¶
EXEC dbo.spMFCreateAllLookups
@ProcessBatch_ID = NULL OUTPUT,
@Schema = N'dbo',
@IncludeInApp = 1,
@WithMetadataSync = 0,
@Debug = 0;
- Returns
1 = Success
-1 = Error
- Parameters
- @ProcessBatch_ID int (optional, output)
Referencing the ID of the ProcessBatch logging table
- @Schema nvarchar(20)
Default = ‘dbo’
Which schema to operate on
- @IncludeInApp int (optional)
Default = 1
- @WithMetadataSync bit (optional)
Default = 0
1 = call spMFDropAndUpdateMetadata internally
- @Debug smallint (optional)
Default = 0
1 = Standard Debug Mode
101 = Advanced Debug Mode
Purpose¶
Prodecedure to create all workflow and Valuelist lookups that is used in the included in App class tables
Changelog¶
Date |
Author |
Description |
2019-08-30 |
JC |
Added documentation |
2019-01-30 |
LC |
Valuelist name: Source Does not exist or is a duplicate |