UFN_DATAFORMWORKFLOWTRIGGER_TRIGGERFORMVALID

create function dbo.UFN_DATAFORMWORKFLOWTRIGGER_TRIGGERFORMVALID
(
    @WORKFLOWID uniqueidentifier,
    @TRIGGERDATAFORMINSTANCEID uniqueidentifier
) 
    returns bit 
    with execute as caller
as
begin

    -- fetch the trigger form mode

    declare @mode smallint;
    select @mode = DFT.MODE
        from dbo.DATAFORMINSTANCECATALOG DFI inner join dbo.DATAFORMTEMPLATECATALOG DFT on DFI.DATAFORMTEMPLATECATALOGID = DFT.ID
        where DFI.ID = @TRIGGERDATAFORMINSTANCEID

    -- view forms can't trigger workflows

    if @mode = 0
        return 0;

    -- fetch the workflow data form 

    declare @workflowDataFormInstanceId uniqueidentifier;
    select @workflowDataFormInstanceId = WF.DATAFORMINSTANCECATALOGID
        from dbo.BBWORKFLOWCATALOG as WF
        where WF.ID = @WORKFLOWID;

    -- if the trigger form is the workflow form, then it's invalid

    if @TRIGGERDATAFORMINSTANCEID = @workflowDataFormInstanceId
        return 0;

    return 1;
end