USP_DATALIST_GIVINGLEVELPROGRAMREPORT

Returns all the giving level programs allowed for a user.

Parameters

Parameter	Parameter Type	Mode	Description
@CURRENTAPPUSER	uniqueidentifier	IN	Current App User
@SITEFILTERMODE	tinyint	IN	Sites
@SITESSELECTED	xml	IN

Definition

Copy



CREATE procedure dbo.USP_DATALIST_GIVINGLEVELPROGRAMREPORT(
  @CURRENTAPPUSER uniqueidentifier,
  @SITEFILTERMODE tinyint,
  @SITESSELECTED xml = null
)
as
    set nocount on;

          select
                        GIVINGLEVELPROGRAM.[ID],
                        GIVINGLEVELPROGRAM.[NAME]
                    from
                        dbo.[GIVINGLEVELPROGRAM]
                    left join
                        dbo.[GIVINGLEVELPROGRAMLEVEL]
                    on
                        GIVINGLEVELPROGRAMLEVEL.[GIVINGLEVELPROGRAMID] = GIVINGLEVELPROGRAM.[ID]
                    left join
                        dbo.SMARTFIELD on SMARTFIELD.[ID] = GIVINGLEVELPROGRAM.[SMARTFIELDID]
          left join
            dbo.GIVINGLEVELPROGRAMSITE on GIVINGLEVELPROGRAMSITE.[GIVINGLEVELPROGRAMID] = GIVINGLEVELPROGRAM.[ID]
          where
          (@SITEFILTERMODE = 0 or GIVINGLEVELPROGRAMSITE.[SITEID] in 
            (select SITEID from dbo.UFN_SITE_BUILDDATALISTSITEFILTER (@CURRENTAPPUSER, @SITEFILTERMODE, @SITESSELECTED))
          )
                    group by
                        GIVINGLEVELPROGRAM.[ID],
                        GIVINGLEVELPROGRAM.[NAME]
                    order by
                        GIVINGLEVELPROGRAM.[NAME];