USP_DATALIST_FUNDINGREQUESTDOCUMENTATION

            CREATE procedure dbo.USP_DATALIST_FUNDINGREQUESTDOCUMENTATION 
            (
                @FUNDINGREQUESTID uniqueidentifier = null,
                @DOCUMENTATIONTYPECODE tinyint = null,
                @TITLE nvarchar(50) = ''
            )
            as
                set nocount on;

                select    
                    FUNDINGREQUESTNOTE.ID,
                    '05c9f19b-52dc-4a13-a419-9964a2de9e67' as [VIEWFORMID],
                    0 as [DOCUMENTATIONTYPECODE],
                    null as [MEDIAURL],
                    null as [FILENAME],
                    null as [FILEFIELDID],
                    'Note' as [DOCUMENTATIONTYPE],
                    FUNDINGREQUESTNOTE.DATEENTERED,
                    FUNDINGREQNOTETYPECODE.DESCRIPTION as [TYPE],
                    FUNDINGREQUESTNOTE.TITLE,
                    NF.NAME as NAME
                from
                    dbo.FUNDINGREQUESTNOTE
                    inner join dbo.FUNDINGREQNOTETYPECODE on FUNDINGREQNOTETYPECODE.ID = FUNDINGREQUESTNOTE.FUNDINGREQNOTETYPECODEID        
                    outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(FUNDINGREQUESTNOTE.AUTHORID) NF
                where 
                    FUNDINGREQUESTNOTE.FUNDINGREQUESTID = @FUNDINGREQUESTID and
                    (@DOCUMENTATIONTYPECODE is null or @DOCUMENTATIONTYPECODE = 0) and
                    (@TITLE = '' or FUNDINGREQUESTNOTE.TITLE like @TITLE + '%')    
                union all    
                select    
                    FUNDINGREQUESTMEDIALINK.ID,
                    '308b2609-6c5e-4e0d-a885-2149b94596f9' as [VIEWFORMID],
                    1 as [DOCUMENTATIONTYPECODE],
                    FUNDINGREQUESTMEDIALINK.MEDIAURL,
                    null,
                    null,
                    'Media link' as [DOCUMENTATIONTYPE],
                    FUNDINGREQUESTMEDIALINK.DATEENTERED,
                    FUNDINGREQMEDIALINKTYPECODE.DESCRIPTION as [TYPE],
                    FUNDINGREQUESTMEDIALINK.TITLE,
                    NF.NAME as NAME
                from
                    dbo.FUNDINGREQUESTMEDIALINK
                    inner join dbo.FUNDINGREQMEDIALINKTYPECODE    on FUNDINGREQMEDIALINKTYPECODE.ID = FUNDINGREQUESTMEDIALINK.FUNDINGREQMEDIALINKTYPECODEID    
                    outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(FUNDINGREQUESTMEDIALINK.AUTHORID) NF
                where 
                    FUNDINGREQUESTMEDIALINK.FUNDINGREQUESTID = @FUNDINGREQUESTID and
                    (@DOCUMENTATIONTYPECODE is null or @DOCUMENTATIONTYPECODE = 1) and
                    (@TITLE = '' or FUNDINGREQUESTMEDIALINK.TITLE like @TITLE + '%')        
                union all    
                select    
                    FUNDINGREQUESTATTACHMENT.ID,
                    '25f3d400-c5f6-4279-a020-fc264833ab5a' as [VIEWFORMID],
                    2 as [DOCUMENTATIONTYPECODE],
                    null,
                    FUNDINGREQUESTATTACHMENT.FILENAME,
                    'FILE',
                    'Attachment' as [DOCUMENTATIONTYPE],
                    FUNDINGREQUESTATTACHMENT.DATEENTERED,
                    FUNDINGREQATTACHMENTTYPECODE.DESCRIPTION as [TYPE],
                    FUNDINGREQUESTATTACHMENT.TITLE,
                    NF.NAME as NAME
                from
                    dbo.FUNDINGREQUESTATTACHMENT
                    inner join dbo.FUNDINGREQATTACHMENTTYPECODE on FUNDINGREQATTACHMENTTYPECODE.ID = FUNDINGREQUESTATTACHMENT.FUNDINGREQATTACHMENTTYPECODEID    
                    outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(FUNDINGREQUESTATTACHMENT.AUTHORID) NF
                where 
                    FUNDINGREQUESTATTACHMENT.FUNDINGREQUESTID = @FUNDINGREQUESTID and
                    (@DOCUMENTATIONTYPECODE is null or @DOCUMENTATIONTYPECODE = 2) and
                    (@TITLE = '' or FUNDINGREQUESTATTACHMENT.TITLE like @TITLE + '%')        
                order by
                    DATEENTERED desc;