USP_DATALIST_PROSPECTPLANFOLLOWUPREPORT
Returns all prospect plan steps that meet the specified criteria.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @PROSPECTQUERYID | uniqueidentifier | IN | Prospect query ID |
| @STARTDATE | datetime | IN | Start date |
| @ENDDATE | datetime | IN | End date |
| @INCLUDECOMPLETEDSTEPS | bit | IN | Include completed steps |
| @OWNERID | uniqueidentifier | IN | Owner ID |
| @STEPTYPE | uniqueidentifier | IN | Step type |
| @PROSPECTSTATUS | uniqueidentifier | IN | Prospect status |
| @INCLUDEHISTORICALPLANS | bit | IN | Include historical plans |
| @PROSPECTMANAGER | uniqueidentifier | IN | Prospect manager |
| @PLANSTAGE | uniqueidentifier | IN | Plan stage |
| @PLANTYPE | uniqueidentifier | IN | Plan type |
| @CURRENTAPPUSERID | uniqueidentifier | IN | Input parameter indicating the ID of the current user. |
| @ONLYOWNEDINTERACTIONS | bit | IN | Only show steps owned by this fundraiser |
| @SECURITYFEATUREID | uniqueidentifier | IN | |
| @SECURITYFEATURETYPE | tinyint | IN |
Definition
Copy
CREATE procedure dbo.USP_DATALIST_PROSPECTPLANFOLLOWUPREPORT
(
@PROSPECTQUERYID uniqueidentifier = null,
@STARTDATE datetime = null,
@ENDDATE datetime = null,
@INCLUDECOMPLETEDSTEPS bit = null,
@OWNERID uniqueidentifier = null,
@STEPTYPE uniqueidentifier = null,
@PROSPECTSTATUS uniqueidentifier = null,
@INCLUDEHISTORICALPLANS bit = null,
@PROSPECTMANAGER uniqueidentifier = null,
@PLANSTAGE uniqueidentifier = null,
@PLANTYPE uniqueidentifier = null,
@CURRENTAPPUSERID uniqueidentifier = null,
@ONLYOWNEDINTERACTIONS bit = 0,
@SECURITYFEATUREID uniqueidentifier = null,
@SECURITYFEATURETYPE tinyint = null
)
as
set nocount on;
exec dbo.USP_REPORT_PROSPECTPLANFOLLOWUP @PROSPECTQUERYID, @STARTDATE, @ENDDATE, @INCLUDECOMPLETEDSTEPS, @OWNERID, @STEPTYPE,
@PROSPECTSTATUS, @INCLUDEHISTORICALPLANS, @PROSPECTMANAGER, @PLANSTAGE, @PLANTYPE, @CURRENTAPPUSERID, @ONLYOWNEDINTERACTIONS,
@SECURITYFEATUREID, @SECURITYFEATURETYPE;
return 0;