USP_DATALIST_CONSTITUENTPROFILEDASHBOARDMEDIA

                    CREATE procedure dbo.USP_DATALIST_CONSTITUENTPROFILEDASHBOARDMEDIA
                    (
                        @CONSTITUENTID uniqueidentifier,
                        @ISVISIBLE bit = 1
                    )
                    as
                        set nocount on;

                        if @ISVISIBLE = 1
                        begin
                            select
                                'Media link' as [DOCUMENTATIONTYPE],
                                CONSTITUENTMEDIALINKTYPECODE.DESCRIPTION as TYPE,
                                CONSTITUENTMEDIALINK.TITLE,
                                CONSTITUENTMEDIALINK.DATEENTERED,
                                CONSTITUENT.NAME as AUTHOR
                            from
                                dbo.CONSTITUENTMEDIALINK
                            inner join
                                dbo.CONSTITUENTMEDIALINKTYPECODE
                            on
                                CONSTITUENTMEDIALINKTYPECODE.ID = CONSTITUENTMEDIALINK.CONSTITUENTMEDIALINKTYPECODEID
                            left join
                                dbo.CONSTITUENT
                            on
                                CONSTITUENT.ID = CONSTITUENTMEDIALINK.AUTHORID
                            where 
                                CONSTITUENTMEDIALINK.CONSTITUENTID = @CONSTITUENTID

                            union all

                            select    
                                'Attachment' as [DOCUMENTATIONTYPE],
                                CONSTITUENTATTACHMENTTYPECODE.DESCRIPTION as TYPE,
                                CONSTITUENTATTACHMENT.TITLE,
                                CONSTITUENTATTACHMENT.DATEENTERED,
                                CONSTITUENT.NAME as AUTHOR
                            from
                                dbo.CONSTITUENTATTACHMENT
                            inner join
                                dbo.CONSTITUENTATTACHMENTTYPECODE
                            on
                                CONSTITUENTATTACHMENTTYPECODE.ID = CONSTITUENTATTACHMENT.CONSTITUENTATTACHMENTTYPECODEID
                            left join
                                dbo.CONSTITUENT
                            on
                                CONSTITUENT.ID = CONSTITUENTATTACHMENT.AUTHORID
                            where 
                                CONSTITUENTATTACHMENT.CONSTITUENTID = @CONSTITUENTID

                            order by
                                DOCUMENTATIONTYPE, TYPE, TITLE, DATEENTERED;
                        end