USP_BANKACCOUNTDEPOSIT_DOCUMENTATION_DATALIST_GETDATA

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

                select    
                    BANKACCOUNTDEPOSITNOTE.ID,
                    '685b2738-165a-4dab-9d4c-09f12ae88cd8' as [VIEWFORMID],
                    0 as [DOCUMENTATIONTYPECODE],
                    null as [MEDIAURL],
                    null as [FILENAME],
                    null as [FILEFIELDID],
                    'Note' as [DOCUMENTATIONTYPE],
                    BANKACCOUNTDEPOSITNOTE.DATEENTERED,
                    BANKACCOUNTDEPOSITNOTETYPECODE.DESCRIPTION as [TYPE],
                    BANKACCOUNTDEPOSITNOTE.TITLE,
                    NF.NAME,
                    dbo.UFN_ANNOTATION_ANNOTATIONEXISTS('Bank Account Deposit Note',BANKACCOUNTDEPOSITNOTE.ID) as ANNOTATIONEXISTS
                from
                    dbo.BANKACCOUNTDEPOSITNOTE
                inner join
                    dbo.BANKACCOUNTDEPOSITNOTETYPECODE
                on
                    BANKACCOUNTDEPOSITNOTETYPECODE.ID = BANKACCOUNTDEPOSITNOTE.BANKACCOUNTDEPOSITNOTETYPECODEID
                outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(BANKACCOUNTDEPOSITNOTE.AUTHORID) NF
                where 
                    BANKACCOUNTDEPOSITNOTE.DEPOSITID = @DEPOSITID and
                    (@DOCUMENTATIONTYPECODE is null or @DOCUMENTATIONTYPECODE = 0) and
                    (@TITLE = '' or BANKACCOUNTDEPOSITNOTE.TITLE like @TITLE + '%')

                union all

                select    
                    BANKACCOUNTDEPOSITMEDIALINK.ID,
                    '56b4fa6b-0b9a-4908-b5a0-c9ae0fd00057' as [VIEWFORMID],
                    1 as [DOCUMENTATIONTYPECODE],
                    BANKACCOUNTDEPOSITMEDIALINK.MEDIAURL,
                    null,
                    null,
                    'Media link' as [DOCUMENTATIONTYPE],
                    BANKACCOUNTDEPOSITMEDIALINK.DATEENTERED,
                    DEPOSITMEDIALINKTYPECODE.DESCRIPTION as [TYPE],
                    BANKACCOUNTDEPOSITMEDIALINK.TITLE,
                    NF.NAME,
                    cast(0 as bit) as ANNOTATIONEXISTS
                from
                    dbo.BANKACCOUNTDEPOSITMEDIALINK
                inner join
                    dbo.DEPOSITMEDIALINKTYPECODE
                on
                    DEPOSITMEDIALINKTYPECODE.ID = BANKACCOUNTDEPOSITMEDIALINK.DEPOSITMEDIALINKTYPECODEID
                outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(BANKACCOUNTDEPOSITMEDIALINK.AUTHORID) NF
                where 
                    BANKACCOUNTDEPOSITMEDIALINK.DEPOSITID = @DEPOSITID and
                    (@DOCUMENTATIONTYPECODE is null or @DOCUMENTATIONTYPECODE = 1) and
                    (@TITLE = '' or BANKACCOUNTDEPOSITMEDIALINK.TITLE like @TITLE + '%')

                union all

                select    
                    BANKACCOUNTDEPOSITATTACHMENT.ID,
                    'f6d7e807-dda4-459c-89e4-08d3c0db7493' as [VIEWFORMID],
                    2 as [DOCUMENTATIONTYPECODE],
                    null,
                    BANKACCOUNTDEPOSITATTACHMENT.FILENAME,
                    'FILE',
                    'Attachment' as [DOCUMENTATIONTYPE],
                    BANKACCOUNTDEPOSITATTACHMENT.DATEENTERED,
                    DEPOSITATTACHMENTTYPECODE.DESCRIPTION as [TYPE],
                    BANKACCOUNTDEPOSITATTACHMENT.TITLE,
                    NF.NAME,
                    cast(0 as bit) as ANNOTATIONEXISTS
                from
                    dbo.BANKACCOUNTDEPOSITATTACHMENT
                inner join
                    dbo.DEPOSITATTACHMENTTYPECODE
                on
                    DEPOSITATTACHMENTTYPECODE.ID = BANKACCOUNTDEPOSITATTACHMENT.DEPOSITATTACHMENTTYPECODEID
                outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(BANKACCOUNTDEPOSITATTACHMENT.AUTHORID) NF
                where 
                    BANKACCOUNTDEPOSITATTACHMENT.DEPOSITID = @DEPOSITID and
                    (@DOCUMENTATIONTYPECODE is null or @DOCUMENTATIONTYPECODE = 2) and
                    (@TITLE = '' or BANKACCOUNTDEPOSITATTACHMENT.TITLE like @TITLE + '%')

                order by
                    DATEENTERED desc;