fnGetDefaultWorkflowID

Return

Return Type
int

Parameters

Parameter Parameter Type Mode Description
@ContentTypesID int IN

Definition

Copy

CREATE function [dbo].[fnGetDefaultWorkflowID]
(
    @ContentTypesID int
)
returns int
as
begin
    declare @WorkflowID int

    if exists(select 1 from dbo.INSTALLEDPRODUCTLIST where ID = '25A6B0A9-E26A-4047-9BC7-DE8B7020C155')
        select @WorkflowID=ID from dbo.Workflow where [ContentTypesID]=@ContentTypesID and [IsDefault]=1

    return @WorkflowID
end