USP_SEARCHLISTREPLACEMENT_GETDATA

Retrieves data about an existing searchlist replacement

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@DATALOADED	bit	INOUT
@TSLONG	bigint	INOUT
@SEARCHLISTNAME	nvarchar(120)	INOUT
@RECORDTYPEID	uniqueidentifier	INOUT
@REPLACEMENTSEARCHLISTID	uniqueidentifier	INOUT

Definition

Copy



CREATE procedure dbo.USP_SEARCHLISTREPLACEMENT_GETDATA(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @TSLONG bigint = 0 output,
    @SEARCHLISTNAME nvarchar(120) = null output,
    @RECORDTYPEID uniqueidentifier = null output,
    @REPLACEMENTSEARCHLISTID uniqueidentifier = null output
)
as

    set nocount on;

    set @DATALOADED = 0
    set @TSLONG = 0

    select
        @DATALOADED = 1,
        @TSLONG = s.TSLONG,
        @SEARCHLISTNAME = c.UINAME,
        @RECORDTYPEID = c.RECORDTYPEID,
        @REPLACEMENTSEARCHLISTID = s.REPLACEMENTSEARCHLISTID
    from dbo.SEARCHLISTSETTINGS s inner join
        dbo.SEARCHLISTCATALOG c on s.ID = c.ID
    where s.ID = @ID

    return 0;