USP_SIMPLEDATALIST_PLANNEDGIFTSITES

List of all sites in the system that a given user could interact with (based on Role assignments) and any sites assigned to the planned gift that the user does not otherwise have access.

Parameters

Parameter	Parameter Type	Mode	Description
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@PLANNEDGIFTID	uniqueidentifier	IN	PLANNEDGIFTID

Definition

Copy



                create procedure dbo.USP_SIMPLEDATALIST_PLANNEDGIFTSITES
                (
                    @CURRENTAPPUSERID uniqueidentifier,
                    @PLANNEDGIFTID uniqueidentifier
                )
                as
                    set nocount on;

                    select                     
                        SFU.[SITEID] as VALUE, 
                        SITE.[NAME] as LABEL                         
                    from                     
                        dbo.SITE 
                        inner join dbo.UFN_SITESFORUSER(@CURRENTAPPUSERID) AS SFU ON SFU.SITEID = SITE.ID
                    union
                    select
                        PLANNEDGIFTSITE.SITEID as VALUE,
                        SITE.NAME as LABEL
                    from
                        dbo.PLANNEDGIFTSITE
                        inner join dbo.SITE on SITE.ID = PLANNEDGIFTSITE.SITEID
                    where
                        PLANNEDGIFTSITE.PLANNEDGIFTID = @PLANNEDGIFTID
                    order by
                        LABEL