USP_DATALIST_DATAFORMADDINS

Lists the addins defined for the given data form instance.

Parameters

Parameter	Parameter Type	Mode	Description
@DATAFORMINSTANCEID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



create procedure dbo.USP_DATALIST_DATAFORMADDINS
(
    @DATAFORMINSTANCEID uniqueidentifier 
)
as
    set nocount on;

    select ID, 
           NAME, 
           DESCRIPTION,
           DATAFORMADDINSPECXML.value('declare namespace bbdfa="bb_appfx_dataformaddin";
                                       /bbdfa:DataFormAddInSpec[1]/@Author', 'nvarchar(500)'),
           ENABLED
    from dbo.DATAFORMADDINCATALOG
    where DATAFORMINSTANCEID = @DATAFORMINSTANCEID
    order by SEQUENCE