USP_DATALIST_INTERACTIONDOCUMENTATION

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

                    select    
                        INTERACTIONNOTE.ID,
                        '4EC56467-5BC9-4977-8B83-4FCD0AC3B9F9' 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,
                        'E7EB7C48-98D2-4EA3-8CB4-7305C3738592' 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,
                        '42BC386E-DAAB-4701-B29A-6BC90FB3894F' 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;