USP_SEARCHLIST_BBWORKFLOWTASK

CREATE procedure dbo.USP_SEARCHLIST_BBWORKFLOWTASK
(
    @LOOKUPID nvarchar(100) = null,
    @MAXROWS smallint = 500
)
as
    set @LOOKUPID = dbo.UFN_SEARCHCRITERIA_GETLIKEPARAMETERVALUE(@LOOKUPID, 0, null);

    select top(@MAXROWS)
        WFT.[ID],
        WFT.LOOKUPID,
        WFT.[TASKSTATUS],
        WFT.[DATEASSIGNED],
        WFIB.NAME as INBOXNAME,
        WFT.[TASKSUBJECT],
        WFT.[CATEGORY],
        WFT.[TASKDESCRIPTION]
    from 
        dbo.BBWORKFLOWTASK as WFT
        inner join dbo.BBWORKFLOWINBOX as WFIB on WFT.BBWORKFLOWINBOXID = WFIB.ID
    where    
        ((@LOOKUPID is null) or (WFT.LOOKUPID like @LOOKUPID))
    order by WFT.DATEADDED DESC;