USP_DATALIST_EVENTNOTES

This datalist returns all notes for an event.

Parameters

Parameter	Parameter Type	Mode	Description
@EVENTID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.
@NOTETYPECODEID	uniqueidentifier	IN	Type
@TITLE	nvarchar(50)	IN	Title

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_EVENTNOTES 
                (
                    @EVENTID uniqueidentifier = null,
                    @NOTETYPECODEID uniqueidentifier = null,
                    @TITLE nvarchar(50) = ''
                )
                as
                    set nocount on;

                    select    
                        EVENTNOTE.ID,
                        EVENTNOTE.DATEENTERED,
                        EVENTNOTETYPECODE.DESCRIPTION,
                        EVENTNOTE.TITLE,
                        dbo.UFN_CONSTITUENT_BUILDNAME(EVENTNOTE.AUTHORID)                        
                    from
                        dbo.EVENTNOTE
                        inner join dbo.EVENTNOTETYPECODE on EVENTNOTETYPECODE.ID = EVENTNOTE.EVENTNOTETYPECODEID                    
                    where 
                        EVENTNOTE.EVENTID = @EVENTID and
                        (@NOTETYPECODEID is null or EVENTNOTE.EVENTNOTETYPECODEID = @NOTETYPECODEID) and
                        (@TITLE = '' or EVENTNOTE.TITLE like @TITLE + '%')
                    order by
                        EVENTNOTE.DATEENTERED desc;