USP_SIMPLEDATALIST_SEARCHLISTSWITHQUICKFIND

Returns a list of search lists that support quick find for a specific record type.

Parameters

Parameter	Parameter Type	Mode	Description
@RECORDTYPE	nvarchar(100)	IN

Definition

Copy



CREATE procedure dbo.USP_SIMPLEDATALIST_SEARCHLISTSWITHQUICKFIND
(
    @RECORDTYPE nvarchar(100) = ''
) 
as    

    set nocount on;

    select 
        V_INSTALLED_SEARCHLISTCATALOG.ID as VALUE, 
        V_INSTALLED_SEARCHLISTCATALOG.UINAME as LABEL 
    from 
        dbo.V_INSTALLED_SEARCHLISTCATALOG
        inner join dbo.RECORDTYPE on RECORDTYPE.ID = V_INSTALLED_SEARCHLISTCATALOG.RECORDTYPEID
    where
        (len(V_INSTALLED_SEARCHLISTCATALOG.QUICKFINDFIELD) > 0) and 
        (RECORDTYPE.NAME = @RECORDTYPE or @RECORDTYPE = '')
    order by 
        V_INSTALLED_SEARCHLISTCATALOG.UINAME;