USP_DATALIST_DESIGNATIONLEVELNOTES

Returns a list of all notes for a fundraising purpose.

Parameters

Parameter	Parameter Type	Mode	Description
@DESIGNATIONLEVELID	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_DESIGNATIONLEVELNOTES 
                (
                    @DESIGNATIONLEVELID uniqueidentifier = null,
                    @NOTETYPECODEID uniqueidentifier = null,
                    @TITLE nvarchar(50) = ''
                )
                as

                select    
                    DESIGNATIONLEVELNOTE.ID, 
                    DESIGNATIONLEVELNOTE.DATEENTERED, 
                    DESIGNATIONLEVELNOTETYPECODE.DESCRIPTION,
                    DESIGNATIONLEVELNOTE.TITLE, 
                    dbo.UFN_CONSTITUENT_BUILDNAME(DESIGNATIONLEVELNOTE.AUTHORID) AUTHOR 

                from dbo.DESIGNATIONLEVELNOTE
                inner join dbo.DESIGNATIONLEVELNOTETYPECODE on dbo.DESIGNATIONLEVELNOTETYPECODE.ID = DESIGNATIONLEVELNOTE.DESIGNATIONLEVELNOTETYPECODEID
                where 
                    DESIGNATIONLEVELNOTE.DESIGNATIONLEVELID = @DESIGNATIONLEVELID 
                    and (@NOTETYPECODEID is null or DESIGNATIONLEVELNOTE.DESIGNATIONLEVELNOTETYPECODEID = @NOTETYPECODEID)
                    and (coalesce(@TITLE, '') = '' or DESIGNATIONLEVELNOTE.TITLE like @TITLE + '%')
                order by DESIGNATIONLEVELNOTE.DATEADDED