USP_DATALIST_USERDEFINEDELEMENTDOCUMENTATION

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

                select    
                    USERDEFINEDELEMENTNOTE.ID,
                    'e098e337-6207-4606-a11a-350e8f9e6257' as [VIEWFORMID],
                    0 as [DOCUMENTATIONTYPECODE],
                    null as [MEDIAURL],
                    null as [FILENAME],
                    null as [FILEFIELDID],
                    'Note' as [DOCUMENTATIONTYPE],
                    USERDEFINEDELEMENTNOTE.DATEENTERED,
                    USERDEFINEDNOTETYPECODE.DESCRIPTION as [TYPE],
                    USERDEFINEDELEMENTNOTE.TITLE,
                    dbo.UFN_CONSTITUENT_BUILDNAME(USERDEFINEDELEMENTNOTE.AUTHORID) as NAME,
                    cast(USERDEFINEDELEMENTNOTE.ID as nvarchar(36)) + ':0' as RSSID,
                    dbo.UFN_ANNOTATION_ANNOTATIONEXISTS('User-defined Element note',USERDEFINEDELEMENTNOTE.ID) as ANNOTATIONEXISTS
                from
                    dbo.USERDEFINEDELEMENTNOTE
                    inner join dbo.USERDEFINEDNOTETYPECODE on USERDEFINEDNOTETYPECODE.ID = USERDEFINEDELEMENTNOTE.USERDEFINEDNOTETYPECODEID        
                where 
                    USERDEFINEDELEMENTNOTE.USERDEFINEDELEMENTID = @USERDEFINEDELEMENTID and
                    (@DOCUMENTATIONTYPECODE is null or @DOCUMENTATIONTYPECODE = 0) and
                    (@TITLE = '' or USERDEFINEDELEMENTNOTE.TITLE like @TITLE + '%')    
                union all    
                select    
                    USERDEFINEDELEMENTMEDIALINK.ID,
                    '4504659c-66d5-4ad1-8927-f7ac80112b98' as [VIEWFORMID],
                    1 as [DOCUMENTATIONTYPECODE],
                    USERDEFINEDELEMENTMEDIALINK.MEDIAURL,
                    null,
                    null,
                    'Media link' as [DOCUMENTATIONTYPE],
                    USERDEFINEDELEMENTMEDIALINK.DATEENTERED,
                    USERDEFINEDMEDIALINKTYPECODE.DESCRIPTION as [TYPE],
                    USERDEFINEDELEMENTMEDIALINK.TITLE,
                    dbo.UFN_CONSTITUENT_BUILDNAME(USERDEFINEDELEMENTMEDIALINK.AUTHORID) as NAME,
                    cast(USERDEFINEDELEMENTMEDIALINK.ID as nvarchar(36)) + ':1' as RSSID,
                    cast(0 as bit) as ANNOTATIONEXISTS
                from
                    dbo.USERDEFINEDELEMENTMEDIALINK
                    inner join dbo.USERDEFINEDMEDIALINKTYPECODE    on USERDEFINEDMEDIALINKTYPECODE.ID = USERDEFINEDELEMENTMEDIALINK.USERDEFINEDMEDIALINKTYPECODEID    
                where 
                    USERDEFINEDELEMENTMEDIALINK.USERDEFINEDELEMENTID = @USERDEFINEDELEMENTID and
                    (@DOCUMENTATIONTYPECODE is null or @DOCUMENTATIONTYPECODE = 1) and
                    (@TITLE = '' or USERDEFINEDELEMENTMEDIALINK.TITLE like @TITLE + '%')        
                union all    
                select    
                    USERDEFINEDELEMENTATTACHMENT.ID,
                    'c228dac2-ded9-45f8-91ad-6b99fbe2ae7d' as [VIEWFORMID],
                    2 as [DOCUMENTATIONTYPECODE],
                    null,
                    USERDEFINEDELEMENTATTACHMENT.FILENAME,
                    'FILE',
                    'Attachment' as [DOCUMENTATIONTYPE],
                    USERDEFINEDELEMENTATTACHMENT.DATEENTERED,
                    USERDEFINEDATTACHMENTTYPECODE.DESCRIPTION as [TYPE],
                    USERDEFINEDELEMENTATTACHMENT.TITLE,
                    dbo.UFN_CONSTITUENT_BUILDNAME(USERDEFINEDELEMENTATTACHMENT.AUTHORID) as NAME,
                    cast(USERDEFINEDELEMENTATTACHMENT.ID as nvarchar(36)) + ':2' as RSSID,
                    cast(0 as bit) as ANNOTATIONEXISTS
                from
                    dbo.USERDEFINEDELEMENTATTACHMENT
                    inner join dbo.USERDEFINEDATTACHMENTTYPECODE on USERDEFINEDATTACHMENTTYPECODE.ID = USERDEFINEDELEMENTATTACHMENT.USERDEFINEDATTACHMENTTYPECODEID    
                where 
                    USERDEFINEDELEMENTATTACHMENT.USERDEFINEDELEMENTID = @USERDEFINEDELEMENTID and
                    (@DOCUMENTATIONTYPECODE is null or @DOCUMENTATIONTYPECODE = 2) and
                    (@TITLE = '' or USERDEFINEDELEMENTATTACHMENT.TITLE like @TITLE + '%')        
                order by
                    DATEENTERED desc;