USP_DATALIST_CONSTITUENTSURVEYDOCUMENTATION

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

                    select    
                        SURVEYNOTE.ID,
                        'aed662f6-be69-42f8-9924-f2b5f2b93cfe' as [VIEWFORMID],
                        SURVEY.ID as SURVEYID,
                        SURVEY.NAME as SURVEYNAME,
                        0 as [DOCUMENTATIONTYPECODE],
                        null as [MEDIAURL],
                        null as [FILENAME],
                        null as [FILEFIELDID],
                        'Note' as [DOCUMENTATIONTYPE],
                        SURVEYNOTE.DATEENTERED,
                        SURVEYNOTETYPECODE.DESCRIPTION as [TYPE],
                        SURVEYNOTE.TITLE,
                        dbo.UFN_CONSTITUENT_BUILDNAME(SURVEYNOTE.AUTHORID) as NAME
                    from
                        dbo.SURVEYNOTE
                        inner join dbo.SURVEYNOTETYPECODE on SURVEYNOTETYPECODE.ID = SURVEYNOTE.SURVEYNOTETYPECODEID
                        inner join dbo.SURVEY on SURVEYNOTE.SURVEYID = SURVEY.ID
                    where 
                        SURVEY.CONSTITUENTID = @CONSTITUENTID 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],
                        SURVEY.ID as SURVEYID,
                        SURVEY.NAME as SURVEYNAME,
                        1 as [DOCUMENTATIONTYPECODE],
                        SURVEYMEDIALINK.MEDIAURL,
                        null,
                        null,
                        'Media link' as [DOCUMENTATIONTYPE],
                        SURVEYMEDIALINK.DATEENTERED,
                        SURVEYMEDIALINKTYPECODE.DESCRIPTION as [TYPE],
                        SURVEYMEDIALINK.TITLE,
                        dbo.UFN_CONSTITUENT_BUILDNAME(SURVEYMEDIALINK.AUTHORID) as NAME
                    from
                        dbo.SURVEYMEDIALINK
                        inner join dbo.SURVEYMEDIALINKTYPECODE    on SURVEYMEDIALINKTYPECODE.ID = SURVEYMEDIALINK.SURVEYMEDIALINKTYPECODEID    
                        inner join dbo.SURVEY on SURVEYMEDIALINK.SURVEYID = SURVEY.ID
                    where 
                        SURVEY.CONSTITUENTID = @CONSTITUENTID 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],
                        SURVEY.ID as SURVEYID,
                        SURVEY.NAME as SURVEYNAME,
                        2 as [DOCUMENTATIONTYPECODE],
                        null,
                        SURVEYATTACHMENT.FILENAME,
                        'FILE',
                        'Attachment' as [DOCUMENTATIONTYPE],
                        SURVEYATTACHMENT.DATEENTERED,
                        SURVEYATTACHMENTTYPECODE.DESCRIPTION as [TYPE],
                        SURVEYATTACHMENT.TITLE,
                        dbo.UFN_CONSTITUENT_BUILDNAME(SURVEYATTACHMENT.AUTHORID) as NAME
                    from
                        dbo.SURVEYATTACHMENT
                        inner join dbo.SURVEYATTACHMENTTYPECODE on SURVEYATTACHMENTTYPECODE.ID = SURVEYATTACHMENT.SURVEYATTACHMENTTYPECODEID    
                        inner join dbo.SURVEY on SURVEYATTACHMENT.SURVEYID = SURVEY.ID
                    where 
                        SURVEY.CONSTITUENTID = @CONSTITUENTID and
                        (@DOCUMENTATIONTYPECODE is null or @DOCUMENTATIONTYPECODE = 2) and
                        (@TITLE = '' or SURVEYATTACHMENT.TITLE like @TITLE + '%')        
                    order by
                        DATEENTERED desc;