USP_DATALIST_COMMITTEECAMPAIGN

This returns a list of all campaigns for a committee.

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



CREATE procedure dbo.USP_DATALIST_COMMITTEECAMPAIGN
(
    @CONSTITUENTID uniqueidentifier
)
as
    set nocount on;

    select 
        CAMPAIGNFUNDRAISER.ID,
        CAMPAIGN.ID CAMPAIGNID,
        CAMPAIGN.NAME,
        dbo.UFN_CAMPAIGNFUNDRAISERPOSITIONCODE_GETDESCRIPTION(CAMPAIGNFUNDRAISER.CAMPAIGNFUNDRAISERPOSITIONCODEID) as POSITION,
        CAMPAIGNFUNDRAISER.DATEFROM,
        CAMPAIGNFUNDRAISER.DATETO,
        dbo.UFN_CAMPAIGNFUNDRAISERTASKCODE_GETDESCRIPTION(CAMPAIGNFUNDRAISER.CAMPAIGNFUNDRAISERTASKCODEID) as TASK
    from dbo.CAMPAIGNFUNDRAISER
    inner join dbo.CAMPAIGN on CAMPAIGNFUNDRAISER.CAMPAIGNID = CAMPAIGN.ID
    where CAMPAIGNFUNDRAISER.CONSTITUENTID = @CONSTITUENTID
    order by CAMPAIGN.NAME;