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