USP_DATALIST_PROSPECTPLAN_OPPORTUNITIES

List of opportunities for a prospect plan.

Parameters

Parameter	Parameter Type	Mode	Description
@PROSPECTPLANID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.
@STATUS	tinyint	IN
@AMOUNT	money	IN
@ASKDATE	datetime	IN

Definition

Copy



            CREATE procedure dbo.USP_DATALIST_PROSPECTPLAN_OPPORTUNITIES
            (
                @PROSPECTPLANID uniqueidentifier,
                @STATUS tinyint = null,
                @AMOUNT money = null,
                @ASKDATE datetime = null
            )
            as begin
            set nocount on;
            -- Select fields required to display in list row based on filters

            select 
                OPPORTUNITY.ID,
                STATUS,
                AMOUNT,
                OPPORTUNITYTYPECODE.DESCRIPTION as OPPORTUNITYTYPE,
                EXPECTEDASKDATE,
                ASKDATE,
                RESPONSEDATE,
                BASECURRENCYID
            from dbo.OPPORTUNITY
                left outer join dbo.OPPORTUNITYTYPECODE on OPPORTUNITYTYPECODE.ID = OPPORTUNITY.OPPORTUNITYTYPECODEID
            where
                OPPORTUNITY.PROSPECTPLANID = @PROSPECTPLANID
                and (@STATUS is null or OPPORTUNITY.STATUSCODE = @STATUS)
                and (@AMOUNT is null or OPPORTUNITY.AMOUNT >= @AMOUNT)
                and (@ASKDATE is null or OPPORTUNITY.ASKDATE >= @ASKDATE)
            order by
                OPPORTUNITY.DATEADDED;

            end