USP_BANKACCOUNTADJUSTMENT_DOCUMENTATION_DATALIST_GETDATA

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

                select    
                    BANKACCOUNTADJUSTMENTNOTE.ID,
                    'cbb504e3-3d3c-4012-b936-eee4498c2035' as [VIEWFORMID],
                    0 as [DOCUMENTATIONTYPECODE],
                    null as [MEDIAURL],
                    null as [FILENAME],
                    null as [FILEFIELDID],
                    'Note' as [DOCUMENTATIONTYPE],
                    BANKACCOUNTADJUSTMENTNOTE.DATEENTERED,
                    ADJUSTMENTNOTETYPECODE.DESCRIPTION as [TYPE],
                    BANKACCOUNTADJUSTMENTNOTE.TITLE,
                    NF.NAME,
                    dbo.UFN_ANNOTATION_ANNOTATIONEXISTS('Bank Account Adjustment Note',BANKACCOUNTADJUSTMENTNOTE.ID) as ANNOTATIONEXISTS
                from
                    dbo.BANKACCOUNTADJUSTMENTNOTE
                inner join
                    dbo.ADJUSTMENTNOTETYPECODE
                on
                    ADJUSTMENTNOTETYPECODE.ID = BANKACCOUNTADJUSTMENTNOTE.ADJUSTMENTNOTETYPECODEID
                outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(BANKACCOUNTADJUSTMENTNOTE.AUTHORID) NF
                where 
                    BANKACCOUNTADJUSTMENTNOTE.ADJUSTMENTID = @ADJUSTMENTID and
                    (@DOCUMENTATIONTYPECODE is null or @DOCUMENTATIONTYPECODE = 0) and
                    (@TITLE = '' or BANKACCOUNTADJUSTMENTNOTE.TITLE like @TITLE + '%')

                union all

                select    
                    BANKACCOUNTADJUSTMENTMEDIALINK.ID,
                    '7e7f17b1-885a-4541-a287-117d0d8016ca' as [VIEWFORMID],
                    1 as [DOCUMENTATIONTYPECODE],
                    BANKACCOUNTADJUSTMENTMEDIALINK.MEDIAURL,
                    null,
                    null,
                    'Media link' as [DOCUMENTATIONTYPE],
                    BANKACCOUNTADJUSTMENTMEDIALINK.DATEENTERED,
                    ADJUSTMENTMEDIALINKTYPECODE.DESCRIPTION as [TYPE],
                    BANKACCOUNTADJUSTMENTMEDIALINK.TITLE,
                    NF.NAME,
                    cast(0 as bit) as ANNOTATIONEXISTS
                from
                    dbo.BANKACCOUNTADJUSTMENTMEDIALINK
                inner join
                    dbo.ADJUSTMENTMEDIALINKTYPECODE
                on
                    ADJUSTMENTMEDIALINKTYPECODE.ID = BANKACCOUNTADJUSTMENTMEDIALINK.ADJUSTMENTMEDIALINKTYPECODEID
                outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(BANKACCOUNTADJUSTMENTMEDIALINK.AUTHORID) NF
                where 
                    BANKACCOUNTADJUSTMENTMEDIALINK.ADJUSTMENTID = @ADJUSTMENTID and
                    (@DOCUMENTATIONTYPECODE is null or @DOCUMENTATIONTYPECODE = 1) and
                    (@TITLE = '' or BANKACCOUNTADJUSTMENTMEDIALINK.TITLE like @TITLE + '%')

                union all

                select    
                    BANKACCOUNTADJUSTMENTATTACHMENT.ID,
                    '75221116-3cc2-4d67-94d4-269952728847' as [VIEWFORMID],
                    2 as [DOCUMENTATIONTYPECODE],
                    null,
                    BANKACCOUNTADJUSTMENTATTACHMENT.FILENAME,
                    'FILE',
                    'Attachment' as [DOCUMENTATIONTYPE],
                    BANKACCOUNTADJUSTMENTATTACHMENT.DATEENTERED,
                    ADJUSTMENTATTACHMENTTYPECODE.DESCRIPTION as [TYPE],
                    BANKACCOUNTADJUSTMENTATTACHMENT.TITLE,
                    NF.NAME,
                    cast(0 as bit) as ANNOTATIONEXISTS
                from
                    dbo.BANKACCOUNTADJUSTMENTATTACHMENT
                inner join
                    dbo.ADJUSTMENTATTACHMENTTYPECODE
                on
                    ADJUSTMENTATTACHMENTTYPECODE.ID = BANKACCOUNTADJUSTMENTATTACHMENT.ADJUSTMENTATTACHMENTTYPECODEID
                outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(BANKACCOUNTADJUSTMENTATTACHMENT.AUTHORID) NF
                where 
                    BANKACCOUNTADJUSTMENTATTACHMENT.ADJUSTMENTID = @ADJUSTMENTID and
                    (@DOCUMENTATIONTYPECODE is null or @DOCUMENTATIONTYPECODE = 2) and
                    (@TITLE = '' or BANKACCOUNTADJUSTMENTATTACHMENT.TITLE like @TITLE + '%')

                order by
                    DATEENTERED desc;