USP_DATALIST_GLACCOUNTCODEDOCUMENTATION

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

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

                select    
                    GLACCOUNTCODENOTE.ID,
                    '453b532e-0fe0-4825-86e7-013cb940cb34' as [VIEWFORMID],
                    0 as [DOCUMENTATIONTYPECODE],
                    null as [MEDIAURL],
                    null as [FILENAME],
                    null as [FILEFIELDID],
                    'Note' as [DOCUMENTATIONTYPE],
                    GLACCOUNTCODENOTE.DATEENTERED,
                    ACCOUNTCODENOTETYPECODE.DESCRIPTION as [TYPE],
                    GLACCOUNTCODENOTE.TITLE,
                    dbo.UFN_CONSTITUENT_BUILDNAME(GLACCOUNTCODENOTE.AUTHORID) as NAME,
                    cast(GLACCOUNTCODENOTE.ID as nvarchar(36)) + ':0' as RSSID,
                    dbo.UFN_ANNOTATION_ANNOTATIONEXISTS('Account Code Note', GLACCOUNTCODENOTE.ID) as ANNOTATIONEXISTS
                from
                    dbo.GLACCOUNTCODENOTE
                    inner join dbo.ACCOUNTCODENOTETYPECODE on ACCOUNTCODENOTETYPECODE.ID = GLACCOUNTCODENOTE.ACCOUNTCODENOTETYPECODEID        
                where 
                    GLACCOUNTCODENOTE.GLACCOUNTCODEID = @GLACCOUNTCODEID and
                    (@DOCUMENTATIONTYPECODE is null or @DOCUMENTATIONTYPECODE = 0) and
                    (@TITLE = '' or GLACCOUNTCODENOTE.TITLE like @TITLE + '%')    
                union all    
                select    
                    GLACCOUNTCODEMEDIALINK.ID,
                    'c3915d8e-aef1-4378-8718-2e6ba60f00e6' as [VIEWFORMID],
                    1 as [DOCUMENTATIONTYPECODE],
                    GLACCOUNTCODEMEDIALINK.MEDIAURL,
                    null,
                    null,
                    'Media link' as [DOCUMENTATIONTYPE],
                    GLACCOUNTCODEMEDIALINK.DATEENTERED,
                    ACCOUNTCODEMEDIALINKTYPECODE.DESCRIPTION as [TYPE],
                    GLACCOUNTCODEMEDIALINK.TITLE,
                    dbo.UFN_CONSTITUENT_BUILDNAME(GLACCOUNTCODEMEDIALINK.AUTHORID) as NAME,
                    cast(GLACCOUNTCODEMEDIALINK.ID as nvarchar(36)) + ':1' as RSSID,
                    cast(0 as bit) as ANNOTATIONEXISTS
                from
                    dbo.GLACCOUNTCODEMEDIALINK
                    inner join dbo.ACCOUNTCODEMEDIALINKTYPECODE    on ACCOUNTCODEMEDIALINKTYPECODE.ID = GLACCOUNTCODEMEDIALINK.ACCOUNTCODEMEDIALINKTYPECODEID    
                where 
                    GLACCOUNTCODEMEDIALINK.GLACCOUNTCODEID = @GLACCOUNTCODEID and
                    (@DOCUMENTATIONTYPECODE is null or @DOCUMENTATIONTYPECODE = 1) and
                    (@TITLE = '' or GLACCOUNTCODEMEDIALINK.TITLE like @TITLE + '%')        
                union all    
                select    
                    GLACCOUNTCODEATTACHMENT.ID,
                    '9ab49a76-b3d8-4246-b2ec-7e74b9961141' as [VIEWFORMID],
                    2 as [DOCUMENTATIONTYPECODE],
                    null,
                    GLACCOUNTCODEATTACHMENT.FILENAME,
                    'FILE',
                    'Attachment' as [DOCUMENTATIONTYPE],
                    GLACCOUNTCODEATTACHMENT.DATEENTERED,
                    ACCTCODEATTACHMENTTYPECODE.DESCRIPTION as [TYPE],
                    GLACCOUNTCODEATTACHMENT.TITLE,
                    dbo.UFN_CONSTITUENT_BUILDNAME(GLACCOUNTCODEATTACHMENT.AUTHORID) as NAME,
                    cast(GLACCOUNTCODEATTACHMENT.ID as nvarchar(36)) + ':2' as RSSID,
                    cast(0 as bit) as ANNOTATIONEXISTS
                from
                    dbo.GLACCOUNTCODEATTACHMENT
                    inner join dbo.ACCTCODEATTACHMENTTYPECODE on ACCTCODEATTACHMENTTYPECODE.ID = GLACCOUNTCODEATTACHMENT.ACCOUNTCODEATTACHMENTTYPECODEID    
                where 
                    GLACCOUNTCODEATTACHMENT.GLACCOUNTCODEID = @GLACCOUNTCODEID and
                    (@DOCUMENTATIONTYPECODE is null or @DOCUMENTATIONTYPECODE = 2) and
                    (@TITLE = '' or GLACCOUNTCODEATTACHMENT.TITLE like @TITLE + '%')        
                order by
                    DATEENTERED desc;