USP_DATALIST_PROSPECTRESEARCHREQUESTCONSTITUENT

This datalist returns all of the constituent research requests in a prospect research request.

Parameters

Parameter	Parameter Type	Mode	Description
@CONTEXTID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.
@STATUSES	tinyint	IN	Status
@INCLUDECANCELED	bit	IN	Include canceled

Definition

Copy



CREATE procedure dbo.USP_DATALIST_PROSPECTRESEARCHREQUESTCONSTITUENT(
    @CONTEXTID uniqueidentifier,
    @STATUSES tinyint = 99,
    @INCLUDECANCELED bit = 0
    )
as
    set nocount on;

    select top(500)
        PRRC.ID,
        PRRC.REQUESTNO,   
        PRRC.DUEDATE,
        C_NF.NAME as CONSTITUENT,
        PRRC.STATUS,
        PRRT.DESCRIPTION as REQUESTTYPE,
        A_NF.NAME as RESEARCHER,
        PRRC.STATUSCODE,
        PRRC.CONSTITUENTID
    from 
        dbo.PROSPECTRESEARCHREQUESTCONSTITUENT PRRC
    left join
        dbo.PROSPECTRESEARCHREQUESTTYPECODE PRRT on PRRT.ID = PRRC.PROSPECTRESEARCHREQUESTTYPECODEID
    outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(PRRC.ASSIGNEDTOID) A_NF
    outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(PRRC.CONSTITUENTID) C_NF
    where 
        PRRC.PROSPECTRESEARCHREQUESTID = @CONTEXTID and
        (@STATUSES = 99 or PRRC.STATUSCODE = @STATUSES) and
        ((PRRC.STATUSCODE <> 6) or @INCLUDECANCELED = 1)
    order by PRRC.DATEADDED desc