USP_DATALIST_PROJECTDOCUMENTATION

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

                set @TITLE = replace(@TITLE, '*', '%')

                select    
                    PROJECTNOTE.ID,
                    '48d85495-535c-49df-9e50-b325abe1d410' as [VIEWFORMID],
                    0 as [DOCUMENTATIONTYPECODE],
                    null as [MEDIAURL],
                    null as [FILENAME],
                    null as [FILEFIELDID],
                    'Note' as [DOCUMENTATIONTYPE],
                    PROJECTNOTE.DATEENTERED,
                    PROJECTNOTETYPECODE.DESCRIPTION as [TYPE],
                    PROJECTNOTE.TITLE,
                    dbo.UFN_CONSTITUENT_BUILDNAME(PROJECTNOTE.AUTHORID) as NAME,
                    cast(PROJECTNOTE.ID as nvarchar(36)) + ':0' as RSSID,
                    dbo.UFN_ANNOTATION_ANNOTATIONEXISTS('Project Note',PROJECTNOTE.ID) as ANNOTATIONEXISTS
                from
                    dbo.PROJECTNOTE
                    inner join dbo.PROJECTNOTETYPECODE on PROJECTNOTETYPECODE.ID = PROJECTNOTE.PROJECTNOTETYPECODEID        
                where 
                    PROJECTNOTE.PROJECTID = @PROJECTID and
                    (@DOCUMENTATIONTYPECODE is null or @DOCUMENTATIONTYPECODE = 0) and
                    (@TITLE = '' or PROJECTNOTE.TITLE like @TITLE + '%')    
                union all    
                select    
                    PROJECTMEDIALINK.ID,
                    '96b8a6d5-6b77-4702-8c99-08ad71da978c' as [VIEWFORMID],
                    1 as [DOCUMENTATIONTYPECODE],
                    PROJECTMEDIALINK.MEDIAURL,
                    null,
                    null,
                    'Media link' as [DOCUMENTATIONTYPE],
                    PROJECTMEDIALINK.DATEENTERED,
                    PROJECTMEDIALINKTYPECODE.DESCRIPTION as [TYPE],
                    PROJECTMEDIALINK.TITLE,
                    dbo.UFN_CONSTITUENT_BUILDNAME(PROJECTMEDIALINK.AUTHORID) as NAME,
                    cast(PROJECTMEDIALINK.ID as nvarchar(36)) + ':1' as RSSID,
                    cast(0 as bit) as ANNOTATIONEXISTS
                from
                    dbo.PROJECTMEDIALINK
                    inner join dbo.PROJECTMEDIALINKTYPECODE    on PROJECTMEDIALINKTYPECODE.ID = PROJECTMEDIALINK.PROJECTMEDIALINKTYPECODEID    
                where 
                    PROJECTMEDIALINK.PROJECTID = @PROJECTID and
                    (@DOCUMENTATIONTYPECODE is null or @DOCUMENTATIONTYPECODE = 1) and
                    (@TITLE = '' or PROJECTMEDIALINK.TITLE like @TITLE + '%')        
                union all    
                select    
                    PROJECTATTACHMENT.ID,
                    '63d2b39f-f1a7-4df6-92d2-027cc5ac3faa' as [VIEWFORMID],
                    2 as [DOCUMENTATIONTYPECODE],
                    null,
                    PROJECTATTACHMENT.FILENAME,
                    'FILE',
                    'Attachment' as [DOCUMENTATIONTYPE],
                    PROJECTATTACHMENT.DATEENTERED,
                    PROJECTATTACHMENTTYPECODE.DESCRIPTION as [TYPE],
                    PROJECTATTACHMENT.TITLE,
                    dbo.UFN_CONSTITUENT_BUILDNAME(PROJECTATTACHMENT.AUTHORID) as NAME,
                    cast(PROJECTATTACHMENT.ID as nvarchar(36)) + ':2' as RSSID,
                    cast(0 as bit) as ANNOTATIONEXISTS
                from
                    dbo.PROJECTATTACHMENT
                    inner join dbo.PROJECTATTACHMENTTYPECODE on PROJECTATTACHMENTTYPECODE.ID = PROJECTATTACHMENT.PROJECTATTACHMENTTYPECODEID    
                where 
                    PROJECTATTACHMENT.PROJECTID = @PROJECTID and
                    (@DOCUMENTATIONTYPECODE is null or @DOCUMENTATIONTYPECODE = 2) and
                    (@TITLE = '' or PROJECTATTACHMENT.TITLE like @TITLE + '%')        
                order by
                    DATEENTERED desc;