USP_DATALIST_PROSPECTPLAN_FUNDRAISERS

List of fundraisers for a given prospect plan.

Parameters

Parameter	Parameter Type	Mode	Description
@PROSPECTPLANID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.
@VIEWINACTIVE	bit	IN	Show prior solicitors

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_PROSPECTPLAN_FUNDRAISERS
                (
                    @PROSPECTPLANID uniqueidentifier,
                    @VIEWINACTIVE bit = 0
                )
                as begin
                    set nocount on;

                    declare @CURRENTDATE datetime;
                    set @CURRENTDATE = getdate();

                    declare @MINCOMPARERESULT int;
                    set @MINCOMPARERESULT = case @VIEWINACTIVE when 0 then 0 else 1 end;

                    select
                        SECONDARYFUNDRAISER.ID,
                        NF.NAME,
                        SOLICITORROLECODE.DESCRIPTION as FUNDRAISERROLE, 
                        SECONDARYFUNDRAISER.DATEFROM,
                        SECONDARYFUNDRAISER.DATETO,
                        SECONDARYFUNDRAISER.FUNDRAISERID,
                        SECONDARYFUNDRAISER.STATUS as TIMEFRAME
                    from 
                        dbo.SECONDARYFUNDRAISER
                        cross apply dbo.UFN_CONSTITUENT_DISPLAYNAME(SECONDARYFUNDRAISER.FUNDRAISERID) NF
                        left outer join dbo.SOLICITORROLECODE on SOLICITORROLECODE.ID=SECONDARYFUNDRAISER.SOLICITORROLECODEID
                    where
                        SECONDARYFUNDRAISER.PROSPECTPLANID = @PROSPECTPLANID
                        and dbo.UFN_DATE_COMPARETODATERANGE(@CURRENTDATE, SECONDARYFUNDRAISER.DATEFROM, SECONDARYFUNDRAISER.DATETO) <= @MINCOMPARERESULT
                    order by
                        TIMEFRAME, NAME, FUNDRAISERROLE;
                end