DBA_GET_WORKFLOW_BY_SUBJECT_EMAIL

[LadyBird0]

USE [HRNet]
GO
/****** Object: StoredProcedure [dbo].[DBA_GET_WORKFLOW_BY_SUBJECT_EMAIL] Script Date: 08/28/2018 15:15:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- Procedure to find a workflow name in the admin console folders, it searches by e-subject.
ALTER PROC [dbo].[DBA_GET_WORKFLOW_BY_SUBJECT_EMAIL](@emailsubject AS VARCHAR(128) )
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;

-- Insert statements for procedure here

SELECT OC_WORKFLOWS.WORKFLOWID,
OC_WORKFLOWS.WORKFLOWNAME, 
OC_WORKFLOWMAILER.HTMLSUBJECT
FROM OC_WORKFLOWS INNER JOIN  
OC_WORKFLOWMAILER 
ON OC_WORKFLOWS.WORKFLOWID = OC_WORKFLOWMAILER.WORKFLOWID  
WHERE OC_WORKFLOWMAILER.HTMLSUBJECT like @emailsubject;
-- To test
-- EXEC dbo.DBA_GET_WORFLOW_FOLDER @workflowname='Update Role when ISLineManager field is changed'
---EXEC dbo.DBA_GET_WORFLOW_FOLDER @workflowname='A%'

END;