USP_DATAFORMTEMPLATE_VIEW_CAMPAIGNPAGEDATA

The load procedure used by the view dataform template "Campaign Page Expression View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@NAME	nvarchar(100)	INOUT	Campaign
@TOPLEVELCAMPAIGNID	uniqueidentifier	INOUT	Top level campaign ID
@ISPARENTCAMPAIGN	bit	INOUT	Is parent campaign
@HASGOALKPIRIGHTS	bit	INOUT	Has goal KPI rights
@HASHIERARCHYGOALKPIRIGHTS	bit	INOUT	Has hierarchy goal KPI rights
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@ISACTIVE	bit	INOUT	Is active
@HASFUNDRAISERGOALKPIRIGHTS	bit	INOUT	Has fundraiser goal KPI rights
@HASGLMAPPING	bit	INOUT	HASGLMAPPING
@HASPRIORITYKPIRIGHTS	bit	INOUT	Has priority KPI rights
@HASSUBPRIORITYKPIRIGHTS	bit	INOUT	Has subpriority KPI rights
@HASCAMPAIGNREVENUEKPIS	bit	INOUT	Has campaign revenue KPIs
@ISBBFR8ADEPLOYED	bit	INOUT	Is BBFR8A deployed

Definition

Copy



                CREATE procedure USP_DATAFORMTEMPLATE_VIEW_CAMPAIGNPAGEDATA (
                    @ID uniqueidentifier,
                    @DATALOADED bit = 0 output,
                    @NAME nvarchar(100) = null output,
                    @TOPLEVELCAMPAIGNID uniqueidentifier = null output,
                    @ISPARENTCAMPAIGN bit = null output,
                    @HASGOALKPIRIGHTS bit = null output,
                    @HASHIERARCHYGOALKPIRIGHTS bit = null output,
                    @CURRENTAPPUSERID uniqueidentifier,
                    @ISACTIVE bit = null output,
                    @HASFUNDRAISERGOALKPIRIGHTS bit = null output,
                    @HASGLMAPPING bit = null output,
                    @HASPRIORITYKPIRIGHTS bit = null output,
                    @HASSUBPRIORITYKPIRIGHTS bit = null output,
                    @HASCAMPAIGNREVENUEKPIS bit = null output,
                    @ISBBFR8ADEPLOYED bit = null output
                ) as begin
                    set nocount on;

                    select
                        @DATALOADED = 1,
                        @NAME = CAMPAIGN.NAME,
                        @HASGOALKPIRIGHTS = dbo.UFN_SECURITY_APPUSER_GRANTED_KPI(@CURRENTAPPUSERID,'6334cd2e-c1e2-408c-8ebb-ef9ddf3d9250'),
                        @HASHIERARCHYGOALKPIRIGHTS = dbo.UFN_SECURITY_APPUSER_GRANTED_KPI(@CURRENTAPPUSERID,'5CFEADAD-1E3E-46A4-ADF5-CA4994732682'),
                        @HASFUNDRAISERGOALKPIRIGHTS = dbo.UFN_SECURITY_APPUSER_GRANTED_KPI(@CURRENTAPPUSERID,'3ac33006-0c14-4227-b375-3bf2e61da1e1'),
                        @ISACTIVE = CAMPAIGN.ISACTIVE,
                        @HASPRIORITYKPIRIGHTS = dbo.UFN_SECURITY_APPUSER_GRANTED_KPI(@CURRENTAPPUSERID,'578ec1b0-4a3e-4598-8c44-99ce532d2d2c'),
                        @HASSUBPRIORITYKPIRIGHTS = dbo.UFN_SECURITY_APPUSER_GRANTED_KPI(@CURRENTAPPUSERID,'16c1a10f-6ff6-451c-b5b3-8fd8f50b7115')
                    from
                        dbo.CAMPAIGN
                    where
                        CAMPAIGN.ID = @ID;

                    declare @HIERARCHYPATH hierarchyid;
                    select @HIERARCHYPATH = CAMPAIGN.HIERARCHYPATH from dbo.CAMPAIGN where CAMPAIGN.ID = @ID;

                    select
                        @TOPLEVELCAMPAIGNID = CAMPAIGN.ID
                    from
                        dbo.CAMPAIGN
                    where
                        @HIERARCHYPATH.IsDescendantOf(CAMPAIGN.HIERARCHYPATH) = 1
                    and
                        CAMPAIGN.HIERARCHYPATH.GetAncestor(1) = hierarchyid::GetRoot();

                    set @ISPARENTCAMPAIGN = 0;
                    if exists (select 1 from dbo.CAMPAIGN where CAMPAIGN.HIERARCHYPATH.GetAncestor(1) = @HIERARCHYPATH)
                        set @ISPARENTCAMPAIGN = 1;

                    if exists (select ID from dbo.PDACCOUNTSTRUCTURE where PDACCOUNTTABLESAVAILABLEFORSEGMENTID = 'FB6CC7F3-DB67-49B7-A1F8-333EB4BDB537')
                        set @HASGLMAPPING = 1;

                    with XMLNAMESPACES ('bb_appfx_dataforms' as DFI)
                    select @HASCAMPAIGNREVENUEKPIS = 1
                    from 
                        dbo.KPIINSTANCE 
                    where 
                        KPIINSTANCE.KPICATALOGID in ('3AC33006-0C14-4227-B375-3BF2E61DA1E1', '6334CD2E-C1E2-408C-8EBB-EF9DDF3D9250', '5CFEADAD-1E3E-46A4-ADF5-CA4994732682',
                                                        '578EC1B0-4A3E-4598-8C44-99CE532D2D2C', '16C1A10F-6FF6-451C-B5B3-8FD8F50B7115', 'C34812AE-1E1F-4B17-8C27-A42E6E4338B0')
                    and
                        KPIINSTANCE.PARAMETERSXML.value('data(/DFI:DataFormItem/DFI:Values/DFI:fv[@ID="CAMPAIGNID"]/DFI:Value)[1]','varchar(36)') = cast(@ID as varchar(36))

                    if exists (select 1 from dbo.[OLAPDATASOURCE] where [ID] = '7B704DFA-64D8-4FE2-BBD4-196A499C61AC')
                        set @ISBBFR8ADEPLOYED = 1;
                    else
                        set @ISBBFR8ADEPLOYED = 0;

                end