USP_DATAFORMINSTANCE_GETEXTENSIONLIST

Returns the list of enabled extensions for the given data form instance

Parameters

Parameter	Parameter Type	Mode	Description
@DATAFORMINSTANCEID	uniqueidentifier	IN

Definition

Copy



CREATE procedure dbo.USP_DATAFORMINSTANCE_GETEXTENSIONLIST(@DATAFORMINSTANCEID uniqueidentifier)    
as
    select DFT.TEMPLATESPECXML
    from dbo.DATAFORMEXTENSION DFX inner join dbo.DATAFORMINSTANCECATALOG DFI on DFX.ID = DFI.ID
         inner join dbo.DATAFORMTEMPLATECATALOG DFT on DFI.DATAFORMTEMPLATECATALOGID = DFT.ID
    where (DFX.DATAFORMINSTANCEID = @DATAFORMINSTANCEID) and (DFX.ENABLED = 1)
  and dbo.UFN_INSTALLEDPRODUCTS_OPTIONALPRODUCTSINSTALLED(DFT.TEMPLATESPECXML.query('declare namespace common="bb_appfx_commontypes";/*/common:InstalledProductList')) = 1
    order by DFX.SEQUENCE