USP_DATALIST_FUNDINGPLANDOCUMENTATION

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

                select    
                    FUNDINGPLANNOTE.ID,
                    'c6a144bf-77cf-413b-96bb-fa71dab56f5e' as [VIEWFORMID],
                    0 as [DOCUMENTATIONTYPECODE],
                    null as [MEDIAURL],
                    null as [FILENAME],
                    null as [FILEFIELDID],
                    'Note' as [DOCUMENTATIONTYPE],
                    FUNDINGPLANNOTE.DATEENTERED,
                    FUNDINGPLANNOTETYPECODE.DESCRIPTION as [TYPE],
                    FUNDINGPLANNOTE.TITLE,
                    NF.NAME as NAME
                from
                    dbo.FUNDINGPLANNOTE
                    inner join dbo.FUNDINGPLANNOTETYPECODE on FUNDINGPLANNOTETYPECODE.ID = FUNDINGPLANNOTE.FUNDINGPLANNOTETYPECODEID        
                    outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(FUNDINGPLANNOTE.AUTHORID) NF
                where 
                    FUNDINGPLANNOTE.FUNDINGPLANID = @FUNDINGPLANID and
                    (@DOCUMENTATIONTYPECODE is null or @DOCUMENTATIONTYPECODE = 0) and
                    (@TITLE = '' or FUNDINGPLANNOTE.TITLE like @TITLE + '%')    
                union all    
                select    
                    FUNDINGPLANMEDIALINK.ID,
                    'f12c042a-59bb-4efb-b721-1a0662a50f1c' as [VIEWFORMID],
                    1 as [DOCUMENTATIONTYPECODE],
                    FUNDINGPLANMEDIALINK.MEDIAURL,
                    null,
                    null,
                    'Media link' as [DOCUMENTATIONTYPE],
                    FUNDINGPLANMEDIALINK.DATEENTERED,
                    FUNDINGPLANMEDIALINKTYPECODE.DESCRIPTION as [TYPE],
                    FUNDINGPLANMEDIALINK.TITLE,
                    NF.NAME as NAME
                from
                    dbo.FUNDINGPLANMEDIALINK
                    inner join dbo.FUNDINGPLANMEDIALINKTYPECODE    on FUNDINGPLANMEDIALINKTYPECODE.ID = FUNDINGPLANMEDIALINK.FUNDINGPLANMEDIALINKTYPECODEID    
                    outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(FUNDINGPLANMEDIALINK.AUTHORID) NF
                where 
                    FUNDINGPLANMEDIALINK.FUNDINGPLANID = @FUNDINGPLANID and
                    (@DOCUMENTATIONTYPECODE is null or @DOCUMENTATIONTYPECODE = 1) and
                    (@TITLE = '' or FUNDINGPLANMEDIALINK.TITLE like @TITLE + '%')        
                union all    
                select    
                    FUNDINGPLANATTACHMENT.ID,
                    '2f59f265-f368-4f30-834c-1f8b06846b23' as [VIEWFORMID],
                    2 as [DOCUMENTATIONTYPECODE],
                    null,
                    FUNDINGPLANATTACHMENT.FILENAME,
                    'FILE',
                    'Attachment' as [DOCUMENTATIONTYPE],
                    FUNDINGPLANATTACHMENT.DATEENTERED,
                    FUNDINGPLANATTACHMENTTYPECODE.DESCRIPTION as [TYPE],
                    FUNDINGPLANATTACHMENT.TITLE,
                    NF.NAME as NAME
                from
                    dbo.FUNDINGPLANATTACHMENT
                    inner join dbo.FUNDINGPLANATTACHMENTTYPECODE on FUNDINGPLANATTACHMENTTYPECODE.ID = FUNDINGPLANATTACHMENT.FUNDINGPLANATTACHMENTTYPECODEID    
                    outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(FUNDINGPLANATTACHMENT.AUTHORID) NF
                where 
                    FUNDINGPLANATTACHMENT.FUNDINGPLANID = @FUNDINGPLANID and
                    (@DOCUMENTATIONTYPECODE is null or @DOCUMENTATIONTYPECODE = 2) and
                    (@TITLE = '' or FUNDINGPLANATTACHMENT.TITLE like @TITLE + '%')        
                order by
                    DATEENTERED desc;