USP_DATALIST_BATCHTEMPLATEFIELDS

CREATE procedure dbo.USP_DATALIST_BATCHTEMPLATEFIELDS(@BATCHTEMPLATEID uniqueidentifier)
as
    --declare @FORMDEFINITIONXML xml;

    --select @FORMDEFINITIONXML = FORMDEFINITIONXML from dbo.BATCHTEMPLATE where ID = @BATCHTEMPLATEID;


    -- Bug 71463 - AdamBu 1/25/10 - Also return the batch type spec xml so we can access its FieldsToHideInImport element.

    select BATCHTEMPLATE.FORMDEFINITIONXML, BATCHTYPECATALOG.SPECXML, BATCHTEMPLATE.PARAMETERSXML, BATCHTYPECATALOG.ID, BATCHTEMPLATE.AUTOSAVEONROWCHANGE
    from dbo.BATCHTEMPLATE 
        inner join dbo.BATCHTYPECATALOG on BATCHTYPECATALOG.ID = BATCHTEMPLATE.BATCHTYPECATALOGID 
    where BATCHTEMPLATE.ID = @BATCHTEMPLATEID;

    /*
    with xmlnamespaces ('bb_appfx_commontypes' as [ns])
    select T.c.value('@FieldID', 'nvarchar(255)') as [FIELDID], 
        T.c.value('@Caption', 'nvarchar(255)') as [CAPTION], 
        T.c.value('@Required', 'nvarchar(5)') as [REQUIRED],
        T.c.value('@Hidden', 'nvarchar(5)') as [HIDDEN],
        case when len(T.c.value('@DefaultValueText', 'nvarchar(4000)')) = 0 then convert(bit, 0) else convert(bit, 1) end as [HASDEFAULTVALUETEXT]
        from @FORMDEFINITIONXML.nodes('ns:FormMetaData/ns:FormFields/ns:FormField') as T(c);
    */