USP_DATAFORMTEMPLATE_VIEW_BATCHCUSTOMFIELDS

The load procedure used by the view dataform template "Batch Template Customize Fields 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.
@BATCHTYPESPECXML	xml	INOUT	Batch type spec xml
@TEMPLATEDATAFORMINSTANCEID	uniqueidentifier	INOUT	Template dataforminstance id
@TYPEFORMUIXML	xml	INOUT	Batch type form xml
@SELECTEDFIELDS	xml	INOUT	Selected fields

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_BATCHCUSTOMFIELDS
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @BATCHTYPESPECXML xml = null output,
  @TEMPLATEDATAFORMINSTANCEID uniqueidentifier = null output,
  @TYPEFORMUIXML xml = null output,
  @SELECTEDFIELDS xml = null output
)
as 
set nocount on;

set @DATALOADED = 0

select 
    @DATALOADED = 1,                
    @BATCHTYPESPECXML = BATCHTYPECATALOG.SPECXML,
  @TEMPLATEDATAFORMINSTANCEID = (Select TEMPLATESPECXML.value('declare namespace bbfa="bb_appfx_editdataformtemplate";/bbfa:EditDataFormTemplateSpec[1]/@DataFormInstanceID','uniqueidentifier') from DATAFORMTEMPLATECATALOG where ID = BATCHTYPECATALOG.EDITROWDATAFORMTEMPLATEID),
  @TYPEFORMUIXML = (select DATAFORMINSTANCECATALOG.FORMUIXML from DATAFORMINSTANCECATALOG where ID = (select TEMPLATESPECXML.value('declare namespace bbfa="bb_appfx_adddataformtemplate";/bbfa:AddDataFormTemplateSpec[1]/@DataFormInstanceID','uniqueidentifier') from DATAFORMTEMPLATECATALOG where ID = BATCHTYPECATALOG.ADDROWDATAFORMTEMPLATEID)),
    @SELECTEDFIELDS = BATCHTEMPLATE.FORMDEFINITIONXML
    from dbo.[BATCHTEMPLATE] inner join BATCHTYPECATALOG on BATCHTEMPLATE.BATCHTYPECATALOGID = BATCHTYPECATALOG.ID
    where BATCHTEMPLATE.ID = @ID;        

return 0;