USP_DATAFORMWORKFLOWTRIGGERS_GETLIST

CREATE procedure dbo.USP_DATAFORMWORKFLOWTRIGGERS_GETLIST
as
    select WFT.TRIGGERFORMINSTANCEID, 
           WF.NAME as WORKFLOWNAME, 
           WF.DATAFORMINSTANCECATALOGID, 
           WFT.WORKFLOWARGSMAP,
           WFT.WORKFLOWID
    from dbo.DATAFORMWORKFLOWTRIGGER WFT inner join dbo.BBWORKFLOWCATALOG WF on WFT.WORKFLOWID = WF.ID
         left outer join dbo.DATAFORMINSTANCECATALOG INSTANCE on WF.DATAFORMINSTANCECATALOGID = INSTANCE.ID
         left outer join dbo.DATAFORMTEMPLATECATALOG TEMPLATE on INSTANCE.DATAFORMTEMPLATECATALOGID = TEMPLATE.ID
    where WFT.ENABLED = 1