USP_DATALIST_SEARCHLISTREPLACEMENTS

Returns a list of all search lists in the system including a column indicating that a search list replacement has been defined.

Parameters

Parameter	Parameter Type	Mode	Description
@RECORDTYPEID	uniqueidentifier	IN	Record type

Definition

Copy



CREATE procedure dbo.USP_DATALIST_SEARCHLISTREPLACEMENTS(@RECORDTYPEID uniqueidentifier = null)
as
    set nocount on;

    select s.ID,
           s.UINAME as NAME,
           s.DESCRIPTION,
           s2.UINAME REPLACEMENTSEARCH,
           r.NAME RECORDTYPE
    from dbo.SEARCHLISTCATALOG s inner join
        dbo.SEARCHLISTSETTINGS t on s.ID = t.ID inner join
        dbo.SEARCHLISTCATALOG s2 on t.REPLACEMENTSEARCHLISTID = s2.ID inner join
        dbo.RECORDTYPE r on s.RECORDTYPEID = r.ID
    where
        @RECORDTYPEID is null or s.RECORDTYPEID = @RECORDTYPEID
    order by s.NAME