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