USP_SIMPLEDATALIST_BATCHTEMPLATEFIELDS
Returns a list of fields for a batch template.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @BATCHTEMPLATEID | uniqueidentifier | IN | BATCHTEMPLATEID |
Definition
Copy
create procedure dbo.USP_SIMPLEDATALIST_BATCHTEMPLATEFIELDS(@BATCHTEMPLATEID uniqueidentifier)
as
declare @FORMDEFINITIONXML xml;
select @FORMDEFINITIONXML = FORMDEFINITIONXML from dbo.BATCHTEMPLATE where ID = @BATCHTEMPLATEID;
with xmlnamespaces ('bb_appfx_commontypes' as [ns])
select T.c.value('@FieldID', 'nvarchar(255)') as [VALUE], T.c.value('@Caption', 'nvarchar(255)') as [LABEL] from @FORMDEFINITIONXML.nodes('ns:FormMetaData/ns:FormFields/ns:FormField') as T(c);