USP_DATALIST_CONSTITUENTINTERACTIONDOCUMENTATION

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

                    select    
                        INTERACTIONNOTE.ID,
                        'FC892CA7-41AF-4f32-8D10-DAA1FDCB4A1D' as [VIEWFORMID],
                        0 as [DOCUMENTATIONTYPECODE],
                        null as [MEDIAURL],
                        null as [FILENAME],
                        null as [FILEFIELDID],
                        'Note' as [DOCUMENTATIONTYPE],
                        INTERACTIONNOTE.DATEENTERED,
                        INTERACTIONNOTETYPECODE.DESCRIPTION as [TYPE],
                        INTERACTIONNOTE.TITLE,
                        AUTHOR_NF.NAME,
                        coalesce(ADDEDBY_NF.NAME, APPUSER.USERNAME)
                    from
                        dbo.INTERACTIONNOTE
                        left join dbo.INTERACTIONNOTETYPECODE on INTERACTIONNOTETYPECODE.ID = INTERACTIONNOTE.INTERACTIONNOTETYPECODEID
                        left join dbo.APPUSER on APPUSER.ID = INTERACTIONNOTE.ENTEREDBYAPPUSERID
                        outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(APPUSER.CONSTITUENTID) ADDEDBY_NF
                        outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(INTERACTIONNOTE.AUTHORID) AUTHOR_NF
                    where 
                        INTERACTIONNOTE.INTERACTIONID = @INTERACTIONID and
                        (@DOCUMENTATIONTYPECODE is null or @DOCUMENTATIONTYPECODE = 0) and
                        (@TITLE = '' or INTERACTIONNOTE.TITLE like @TITLE + '%')

                    union all

                    select    
                        INTERACTIONMEDIALINK.ID,
                        '7F956A38-C7BC-4faa-B6B0-8618233268D6' as [VIEWFORMID],
                        1 as [DOCUMENTATIONTYPECODE],
                        INTERACTIONMEDIALINK.MEDIAURL,
                        null,
                        null,
                        'Media link' as [DOCUMENTATIONTYPE],
                        INTERACTIONMEDIALINK.DATEENTERED,
                        INTERACTIONMEDIALINKTYPECODE.DESCRIPTION as [TYPE],
                        INTERACTIONMEDIALINK.TITLE,
                        AUTHOR_NF.NAME,
                        coalesce(ADDEDBY_NF.NAME, APPUSER.USERNAME)
                    from
                        dbo.INTERACTIONMEDIALINK
                        left join dbo.INTERACTIONMEDIALINKTYPECODE on INTERACTIONMEDIALINKTYPECODE.ID = INTERACTIONMEDIALINK.INTERACTIONMEDIALINKTYPECODEID
                        left join dbo.APPUSER on APPUSER.ID = INTERACTIONMEDIALINK.ENTEREDBYAPPUSERID
                        outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(APPUSER.CONSTITUENTID) ADDEDBY_NF
                        outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(INTERACTIONMEDIALINK.AUTHORID) AUTHOR_NF
                    where 
                        INTERACTIONMEDIALINK.INTERACTIONID = @INTERACTIONID and
                        (@DOCUMENTATIONTYPECODE is null or @DOCUMENTATIONTYPECODE = 1) and
                        (@TITLE = '' or INTERACTIONMEDIALINK.TITLE like @TITLE + '%')

                    union all

                    select    
                        INTERACTIONATTACHMENT.ID,
                        'F1EE1C4A-7DA1-4ef1-9AD7-D8F8C7BEF250' as [VIEWFORMID],
                        2 as [DOCUMENTATIONTYPECODE],
                        null,
                        INTERACTIONATTACHMENT.FILENAME,
                        'FILE',
                        'Attachment' as [DOCUMENTATIONTYPE],
                        INTERACTIONATTACHMENT.DATEENTERED,
                        INTERACTIONATTACHMENTTYPECODE.DESCRIPTION as [TYPE],
                        INTERACTIONATTACHMENT.TITLE,
                        AUTHOR_NF.NAME,
                        coalesce(ADDEDBY_NF.NAME, APPUSER.USERNAME)
                    from
                        dbo.INTERACTIONATTACHMENT
                        left join dbo.INTERACTIONATTACHMENTTYPECODE on INTERACTIONATTACHMENTTYPECODE.ID = INTERACTIONATTACHMENT.INTERACTIONATTACHMENTTYPECODEID
                        left join dbo.APPUSER on APPUSER.ID = INTERACTIONATTACHMENT.ENTEREDBYAPPUSERID
                        outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(APPUSER.CONSTITUENTID) ADDEDBY_NF
                        outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(INTERACTIONATTACHMENT.AUTHORID) AUTHOR_NF
                    where 
                        INTERACTIONATTACHMENT.INTERACTIONID = @INTERACTIONID and
                        (@DOCUMENTATIONTYPECODE is null or @DOCUMENTATIONTYPECODE = 2) and
                        (@TITLE = '' or INTERACTIONATTACHMENT.TITLE like @TITLE + '%')

                    order by
                        DATEENTERED desc;