USP_DATALIST_SEARCHLISTOUTPUT

Displays the output columns for the given search list.

Parameters

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

Definition

Copy



CREATE procedure dbo.USP_DATALIST_SEARCHLISTOUTPUT
(
    @SEARCHLISTID uniqueidentifier
)
as
    set nocount on;

    with xmlnamespaces ('bb_appfx_searchlist' as tns, 'bb_appfx_commontypes' as common)
    select 
        searchlistoutput.fields.value('@FieldID', 'nvarchar(max)') as FIELDID,
        searchlistoutput.fields.value('@Caption', 'nvarchar(max)') as CAPTION,
        coalesce(searchlistoutput.fields.value('@DataType', 'nvarchar(18)'), 'String') as DATATYPE,
        coalesce(searchlistoutput.fields.value('@IsHidden', 'bit'), 0) as HIDDEN,
        dbo.UFN_INSTALLEDPRODUCTS_TRANSLATELIST(searchlistoutput.fields.query('common:InstalledProductList')) as INSTALLEDPRODUCTSLIST,
        dbo.UFN_INSTALLEDPRODUCTS_OPTIONALPRODUCTSINSTALLED(searchlistoutput.fields.query('common:InstalledProductList')) as INSTALLED
    from dbo.SEARCHLISTCATALOG as S
        cross apply S.SEARCHLISTSPEC.nodes('tns:SearchListSpec/tns:Output/tns:OutputFields/tns:OutputField') as searchlistoutput(fields)
    where S.ID = @SEARCHLISTID