USP_DATALIST_AVAILABLEBATCHDESIGNS

Returns a list of all batch designs available for a given user.

Parameters

Parameter	Parameter Type	Mode	Description
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.

Definition

Copy



CREATE procedure dbo.USP_DATALIST_AVAILABLEBATCHDESIGNS(@CURRENTAPPUSERID uniqueidentifier)
as                
        select [BATCHTEMPLATE].[ID],
            case when len(BATCHTYPECATALOG.AMOUNTCOLUMN) > 0 then 1 else 0 end as DISPLAYAMOUNT,
            BATCHTYPECATALOG.SPECXML,
            (Select TEMPLATESPECXML.value('declare namespace bbfa="bb_appfx_editdataformtemplate";/bbfa:EditDataFormTemplateSpec[1]/@DataFormInstanceID','uniqueidentifier') from DATAFORMTEMPLATECATALOG where ID = BATCHTYPECATALOG.EDITROWDATAFORMTEMPLATEID),
            (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)),
            BATCHTEMPLATE.FORMDEFINITIONXML
        from dbo.[BATCHTEMPLATE] inner join BATCHTYPECATALOG on BATCHTEMPLATE.BATCHTYPECATALOGID = BATCHTYPECATALOG.ID
        where dbo.UFN_SECURITY_APPUSER_GRANTED_BATCHPROCESSOR(@CURRENTAPPUSERID, BATCHTEMPLATE.ID) = 1
        and 1 = dbo.UFN_INSTALLEDPRODUCTS_OPTIONALPRODUCTSINSTALLED
            (
                BATCHTYPECATALOG.SPECXML.query
                    (
                        'declare namespace common="bb_appfx_commontypes";
                        /*/common:InstalledProductList'
                    )
            )
        order by BATCHTEMPLATE.NAME;