USP_DATAFORMTEMPLATE_VIEW_RELATIONSHIPMAP

The load procedure used by the view dataform template "Relationship Map View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	nvarchar(255)	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.
@RELATIONSHIPMAPID	uniqueidentifier	INOUT	RELATIONSHIPMAPID
@RELATIONSHIPMAPINSTANCEID	uniqueidentifier	INOUT	RELATIONSHIPMAPINSTANCEID
@CONTEXTRECORDID	nvarchar(4000)	INOUT	CONTEXTRECORDID
@RELATIONSHIPMAPSPECXML	xml	INOUT	RELATIONSHIPMAPSPECXML
@INSTANCENAME	nvarchar(100)	INOUT	INSTANCENAME
@INSTANCEDESCRIPTION	nvarchar(1000)	INOUT	INSTANCEDESCRIPTION
@INSTANCEDEFINITIONXML	xml	INOUT	INSTANCEDEFINITIONXML
@INSTANCEPARAMETERDEFINITIONXML	xml	INOUT	INSTANCEPARAMETERDEFINITIONXML
@INSTANCEOWNERID	uniqueidentifier	INOUT	INSTANCEOWNERID
@INSTANCEOTHERSCANMODIFY	bit	INOUT	INSTANCEOTHERSCANMODIFY

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_RELATIONSHIPMAP
(
    @ID nvarchar(255),
    @DATALOADED bit = 0 output,
    @RELATIONSHIPMAPID uniqueidentifier = null output,
    @RELATIONSHIPMAPINSTANCEID uniqueidentifier = null output,
    @CONTEXTRECORDID nvarchar(4000) = null output,
    @RELATIONSHIPMAPSPECXML xml = null output,
    @INSTANCENAME nvarchar(100) = null output,
    @INSTANCEDESCRIPTION nvarchar(1000) = null output,
    @INSTANCEDEFINITIONXML xml = null output,
    @INSTANCEPARAMETERDEFINITIONXML xml = null output,
    @INSTANCEOWNERID uniqueidentifier = null output,
    @INSTANCEOTHERSCANMODIFY bit = null output
)
as
    set nocount on;

    set @DATALOADED = 0;

    set @RELATIONSHIPMAPID = substring(@ID, 1, 36);
    set @RELATIONSHIPMAPINSTANCEID = substring(@ID, 38, 36);
    set @CONTEXTRECORDID = case when len(@ID) > 75 then substring(@ID, 75, len(@ID) - 74) end;

    select 
        @DATALOADED = 1,
        @RELATIONSHIPMAPSPECXML = RELATIONSHIPMAPSPECXML
    from dbo.RELATIONSHIPMAPCATALOG
    where ID = @RELATIONSHIPMAPID
        and 1 = dbo.UFN_INSTALLEDPRODUCTS_OPTIONALPRODUCTSINSTALLED
        (
            RELATIONSHIPMAPCATALOG.RELATIONSHIPMAPSPECXML.query
                (
                    'declare namespace common="bb_appfx_commontypes";
                    /*/common:InstalledProductList'
                )
        );

    select
        @INSTANCENAME = NAME,
        @INSTANCEDESCRIPTION = DESCRIPTION,
        @INSTANCEDEFINITIONXML = DEFINITIONXML,
        @INSTANCEPARAMETERDEFINITIONXML = PARAMETERDEFINITIONXML,
        @INSTANCEOWNERID = OWNERID,
        @INSTANCEOTHERSCANMODIFY = OTHERSCANMODIFY
    from dbo.RELATIONSHIPMAPINSTANCE
        where ID = @RELATIONSHIPMAPINSTANCEID;

    return 0;