USP_SEARCHLISTSETTINGS_GETSETTINGS

Returns the search list spec and current settings for the given search list ID

Parameters

Parameter	Parameter Type	Mode
@SEARCHLISTID	uniqueidentifier	IN
@SETTINGSXML	xml	INOUT
@ISCONFIGURABLE	bit	INOUT

Definition

Copy



create procedure dbo.[USP_SEARCHLISTSETTINGS_GETSETTINGS]
    (
        @SEARCHLISTID uniqueidentifier,
        @SETTINGSXML xml output,
        @ISCONFIGURABLE bit output
    )

    as
    begin

        set nocount on;

        set @ISCONFIGURABLE = 0;

        select @SETTINGSXML = SEARCHLISTSETTINGS.SETTINGSXML, @ISCONFIGURABLE = 1
            from dbo.SEARCHLISTCATALOG left outer join dbo.SEARCHLISTSETTINGS on SEARCHLISTCATALOG.ID = SEARCHLISTSETTINGS.ID
            where SEARCHLISTCATALOG.ID = @SEARCHLISTID 
                and SEARCHLISTCATALOG.SEARCHLISTSPEC.exist('declare namespace srch="bb_appfx_searchlist";/srch:SearchListSpec[1]/srch:OptionalFields') = 1;

        return 0;

    end