USP_DATALIST_PROSPECTRESEARCHREQUESTCONSTITUENTSFORREQUEST

This datalist returns a list of constituents for a request.

Parameters

Parameter	Parameter Type	Mode	Description
@CONTEXTID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.
@RECORDTYPECODE	tinyint	IN	Record type
@MAXROWS	int	IN

Definition

Copy



CREATE procedure dbo.USP_DATALIST_PROSPECTRESEARCHREQUESTCONSTITUENTSFORREQUEST(
    @CONTEXTID uniqueidentifier,
    @RECORDTYPECODE tinyint,
  @MAXROWS int = 501
)
as
    set nocount on;

if @RECORDTYPECODE = 1
    select top (@MAXROWS)
        C.ID,
        C.NAME
    from
        dbo.CONSTITUENT C
    left join
        dbo.REGISTRANT REG on REG.CONSTITUENTID = C.ID
    where
        REG.EVENTID = @CONTEXTID and C.ISORGANIZATION = 0
    order by C.KEYNAME asc, C.FIRSTNAME asc
else if @RECORDTYPECODE = 2
    select top (@MAXROWS) 
        C.ID,
        C.NAME
    from 
        dbo.RESEARCHGROUPMEMBER RGM
    left join 
        dbo.CONSTITUENT C on C.ID = RGM.CONSTITUENTID and C.ISORGANIZATION = 0
    where 
        RGM.RESEARCHGROUPID = @CONTEXTID
    order by C.KEYNAME asc, C.FIRSTNAME asc