USP_DATALIST_WORKFLOWTRIGGERS

create procedure dbo.USP_DATALIST_WORKFLOWTRIGGERS
as
    set nocount on;

    select WFT.ID,
           0,
           'Data form',
           INSTANCE.FORMNAME, 
           BBWF.NAME,
           WFT.ENABLED
    from dbo.DATAFORMWORKFLOWTRIGGER as WFT
        inner join dbo.DATAFORMINSTANCECATALOG as INSTANCE on WFT.TRIGGERFORMINSTANCEID = INSTANCE.ID
        inner join dbo.BBWORKFLOWCATALOG as BBWF on WFT.WORKFLOWID = BBWF.ID

    union all
    select WFT.ID,
           1, 
           'Record operation',
           R.DISPLAYNAME, 
           BBWF.NAME,
           WFT.ENABLED
    from dbo.RECORDOPERATIONWORKFLOWTRIGGER as WFT
        inner join dbo.RECORDOPERATIONCATALOG as R on WFT.RECORDOPERATIONID = R.ID
        inner join dbo.BBWORKFLOWCATALOG as BBWF on WFT.WORKFLOWID = BBWF.ID

    union all
    select WFT.ID,
           2, 
           'Feed alert instance',
           INSTANCE.NAME, 
           BBWF.NAME,
           WFT.ENABLED
    from dbo.FEEDALERTINSTANCEWORKFLOWTRIGGER as WFT
        inner join dbo.FEEDALERTINSTANCE as INSTANCE on WFT.FEEDALERTINSTANCEID = INSTANCE.ID
        inner join dbo.BBWORKFLOWCATALOG as BBWF on WFT.WORKFLOWID = BBWF.ID