USP_DATALIST_CAMPAIGNHIERARCHYNAVIGATIONTREE

This datalist is the page navigation tree used by the campaign page.

Parameters

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

Definition

Copy



                    CREATE procedure dbo.USP_DATALIST_CAMPAIGNHIERARCHYNAVIGATIONTREE (
                        @CAMPAIGNID uniqueidentifier
                    ) as

                        select
                            CAMPAIGN.ID as CONTEXTID,
                            'c4fd3595-e410-4be6-b70e-e0660f40b6aa' as PAGEID,
                            CAMPAIGN.NAME as CAPTION,
                            (select * from dbo.UFN_CAMPAIGNHIERARCHY_NODES(CAMPAIGN.HIERARCHYPATH) for xml raw('NODE'), root('NODES'), elements, type) as NODES
                        from
                            dbo.CAMPAIGN
                        where
                            CAMPAIGN.ID = @CAMPAIGNID