USP_DATALIST_ORGANIZATIONPOSITIONHISTORY

This datalist returns all fundraiser history for a given position.

Parameters

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

Definition

Copy



                create procedure dbo.USP_DATALIST_ORGANIZATIONPOSITIONHISTORY 
                (
                    @POSITIONID uniqueidentifier = null
                )
                as
                    set nocount on;

                    select    ORGANIZATIONPOSITIONHOLDER.ID, 
                            CONSTITUENT.ID,
                            coalesce(CONSTITUENT.NAME, '<Vacant>'),
                            ORGANIZATIONPOSITIONHOLDER.DATEFROM,
                            ORGANIZATIONPOSITIONHOLDER.DATETO
                        from ORGANIZATIONPOSITIONHOLDER 
                        left outer join CONSTITUENT
                            on CONSTITUENT.ID = ORGANIZATIONPOSITIONHOLDER.CONSTITUENTID
                        where POSITIONID = @POSITIONID
                        order by DATEFROM;