USP_DATALIST_SURVEYDOCUMENTATION

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

                select    
                    SURVEYNOTE.ID,
                    'aed662f6-be69-42f8-9924-f2b5f2b93cfe' as [VIEWFORMID],
                    0 as [DOCUMENTATIONTYPECODE],
                    null as [MEDIAURL],
                    null as [FILENAME],
                    null as [FILEFIELDID],
                    'Note' as [DOCUMENTATIONTYPE],
                    SURVEYNOTE.DATEENTERED,
                    SURVEYNOTETYPECODE.DESCRIPTION as [TYPE],
                    SURVEYNOTE.TITLE,
                    NF.NAME as NAME
                from
                    dbo.SURVEYNOTE
                    inner join dbo.SURVEYNOTETYPECODE on SURVEYNOTETYPECODE.ID = SURVEYNOTE.SURVEYNOTETYPECODEID        
                    outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(SURVEYNOTE.AUTHORID) NF
                where 
                    SURVEYNOTE.SURVEYID = @SURVEYID and
                    (@DOCUMENTATIONTYPECODE is null or @DOCUMENTATIONTYPECODE = 0) and
                    (@TITLE = '' or SURVEYNOTE.TITLE like @TITLE + '%')    
                union all    
                select    
                    SURVEYMEDIALINK.ID,
                    '24445163-1ab5-4952-92c2-1d93e048bd2d' as [VIEWFORMID],
                    1 as [DOCUMENTATIONTYPECODE],
                    SURVEYMEDIALINK.MEDIAURL,
                    null,
                    null,
                    'Media link' as [DOCUMENTATIONTYPE],
                    SURVEYMEDIALINK.DATEENTERED,
                    SURVEYMEDIALINKTYPECODE.DESCRIPTION as [TYPE],
                    SURVEYMEDIALINK.TITLE,
                    NF.NAME as NAME
                from
                    dbo.SURVEYMEDIALINK
                    inner join dbo.SURVEYMEDIALINKTYPECODE    on SURVEYMEDIALINKTYPECODE.ID = SURVEYMEDIALINK.SURVEYMEDIALINKTYPECODEID    
                    outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(SURVEYMEDIALINK.AUTHORID) NF
                where 
                    SURVEYMEDIALINK.SURVEYID = @SURVEYID and
                    (@DOCUMENTATIONTYPECODE is null or @DOCUMENTATIONTYPECODE = 1) and
                    (@TITLE = '' or SURVEYMEDIALINK.TITLE like @TITLE + '%')        
                union all    
                select    
                    SURVEYATTACHMENT.ID,
                    '00655e20-1613-493a-99d2-db2958dbefd8' as [VIEWFORMID],
                    2 as [DOCUMENTATIONTYPECODE],
                    null,
                    SURVEYATTACHMENT.FILENAME,
                    'FILE',
                    'Attachment' as [DOCUMENTATIONTYPE],
                    SURVEYATTACHMENT.DATEENTERED,
                    SURVEYATTACHMENTTYPECODE.DESCRIPTION as [TYPE],
                    SURVEYATTACHMENT.TITLE,
                    NF.NAME as NAME
                from
                    dbo.SURVEYATTACHMENT
                    inner join dbo.SURVEYATTACHMENTTYPECODE on SURVEYATTACHMENTTYPECODE.ID = SURVEYATTACHMENT.SURVEYATTACHMENTTYPECODEID    
                    outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(SURVEYATTACHMENT.AUTHORID) NF
                where 
                    SURVEYATTACHMENT.SURVEYID = @SURVEYID and
                    (@DOCUMENTATIONTYPECODE is null or @DOCUMENTATIONTYPECODE = 2) and
                    (@TITLE = '' or SURVEYATTACHMENT.TITLE like @TITLE + '%')        
                order by
                    DATEENTERED desc;