USP_DATALIST_VOLUNTEERDOCUMENTATION

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

                    select    
                        VOLUNTEERNOTE.ID,
                        '9CA546D7-CD95-4BFB-91FD-EC43D7441B69' as [VIEWFORMID],
                        0 as [DOCUMENTATIONTYPECODE],
                        null as [MEDIAURL],
                        null as [FILENAME],
                        null as [FILEFIELDID],
                        'Note' as [DOCUMENTATIONTYPE],
                        VOLUNTEERNOTE.DATEENTERED,
                        VOLUNTEERNOTETYPECODE.DESCRIPTION as [TYPE],
                        VOLUNTEERNOTE.TITLE,
                        NF.NAME
                    from
                        dbo.VOLUNTEERNOTE
                    inner join
                        dbo.VOLUNTEERNOTETYPECODE
                    on
                        VOLUNTEERNOTETYPECODE.ID = VOLUNTEERNOTE.VOLUNTEERNOTETYPECODEID
                    outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(VOLUNTEERNOTE.AUTHORID) NF
                    where 
                        VOLUNTEERNOTE.VOLUNTEERID = @VOLUNTEERID and
                        (@DOCUMENTATIONTYPECODE is null or @DOCUMENTATIONTYPECODE = 0) and
                        (@TITLE = '' or VOLUNTEERNOTE.TITLE like @TITLE + '%')

                    union all

                    select    
                        VOLUNTEERMEDIALINK.ID,
                        '4E94FF16-03E5-44F5-8AB6-EA155A43DDE7' as [VIEWFORMID],
                        1 as [DOCUMENTATIONTYPECODE],
                        VOLUNTEERMEDIALINK.MEDIAURL,
                        null,
                        null,
                        'Media link' as [DOCUMENTATIONTYPE],
                        VOLUNTEERMEDIALINK.DATEENTERED,
                        VOLUNTEERMEDIALINKTYPECODE.DESCRIPTION as [TYPE],
                        VOLUNTEERMEDIALINK.TITLE,
                        NF.NAME
                    from
                        dbo.VOLUNTEERMEDIALINK
                    inner join
                        dbo.VOLUNTEERMEDIALINKTYPECODE
                    on
                        VOLUNTEERMEDIALINKTYPECODE.ID = VOLUNTEERMEDIALINK.VOLUNTEERMEDIALINKTYPECODEID
                    outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(VOLUNTEERMEDIALINK.AUTHORID) NF
                    where 
                        VOLUNTEERMEDIALINK.VOLUNTEERID = @VOLUNTEERID and
                        (@DOCUMENTATIONTYPECODE is null or @DOCUMENTATIONTYPECODE = 1) and
                        (@TITLE = '' or VOLUNTEERMEDIALINK.TITLE like @TITLE + '%')

                    union all

                    select    
                        VOLUNTEERATTACHMENT.ID,
                        '3D9EC598-CCBB-48BE-A6BB-B03BC1A20BEE' as [VIEWFORMID],
                        2 as [DOCUMENTATIONTYPECODE],
                        null,
                        VOLUNTEERATTACHMENT.FILENAME,
                        'FILE',
                        'Attachment' as [DOCUMENTATIONTYPE],
                        VOLUNTEERATTACHMENT.DATEENTERED,
                        VOLUNTEERATTACHMENTTYPECODE.DESCRIPTION as [TYPE],
                        VOLUNTEERATTACHMENT.TITLE,
                        NF.NAME
                    from
                        dbo.VOLUNTEERATTACHMENT
                    inner join
                        dbo.VOLUNTEERATTACHMENTTYPECODE
                    on
                        VOLUNTEERATTACHMENTTYPECODE.ID = VOLUNTEERATTACHMENT.VOLUNTEERATTACHMENTTYPECODEID
                    outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(VOLUNTEERATTACHMENT.AUTHORID) NF
                    where 
                        VOLUNTEERATTACHMENT.VOLUNTEERID = @VOLUNTEERID and
                        (@DOCUMENTATIONTYPECODE is null or @DOCUMENTATIONTYPECODE = 2) and
                        (@TITLE = '' or VOLUNTEERATTACHMENT.TITLE like @TITLE + '%')

                    order by
                        DATEENTERED desc;