USP_DATALIST_DATALISTOUTPUT

Displays the output columns for the given data list.

Parameters

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

Definition

Copy



create procedure dbo.USP_DATALIST_DATALISTOUTPUT
(
    @DATALISTID uniqueidentifier
)
as
    set nocount on;

    with xmlnamespaces ('bb_appfx_datalist' as tns, 'bb_appfx_commontypes' as common)
    select 
        datalistoutput.fields.value('@FieldID', 'nvarchar(max)') as FIELDID,
        datalistoutput.fields.value('@Caption', 'nvarchar(max)') as CAPTION,
        coalesce(datalistoutput.fields.value('@DataType', 'nvarchar(18)'), 'String') as DATATYPE,
        coalesce(datalistoutput.fields.value('@IsHidden', 'bit'), 0) as HIDDEN,
        dbo.UFN_INSTALLEDPRODUCTS_TRANSLATELIST(datalistoutput.fields.query('common:InstalledProductList')) as INSTALLEDPRODUCTSLIST,
        dbo.UFN_INSTALLEDPRODUCTS_OPTIONALPRODUCTSINSTALLED(datalistoutput.fields.query('common:InstalledProductList')) as INSTALLED
    from dbo.DATALISTCATALOG as D
        cross apply D.DATALISTSPEC.nodes('tns:DataListSpec/tns:Output/tns:OutputFields/tns:OutputField') as datalistoutput(fields)
    where D.ID = @DATALISTID