USP_SEARCHLIST_UIWIDGET

Search for a UI widget.

Parameters

Parameter	Parameter Type	Mode	Description
@MAXROWS	smallint	IN	Input parameter indicating the maximum number of rows to return.
@NAME	nvarchar(255)	IN	Name
@RECORDTYPEID	uniqueidentifier	IN	Record type

Definition

Copy



CREATE procedure dbo.USP_SEARCHLIST_UIWIDGET
(
    @MAXROWS smallint = 500,
    @NAME nvarchar(255) = null,
    @RECORDTYPEID uniqueidentifier = null
)
as
    set nocount on;

    set @NAME = dbo.UFN_SEARCHCRITERIA_GETLIKEPARAMETERVALUE(@NAME, 0, null);

    if @RECORDTYPEID = '00000000-0000-0000-0000-000000000000'
        set @RECORDTYPEID = null;

    select top(@MAXROWS)
        U.ID,
        U.NAME,
        U.DESCRIPTION,
        RT.NAME as RECORDTYPENAME
    from 
        dbo.UIWIDGETCATALOG as U left outer join dbo.RECORDTYPE as RT on U.CONTEXTRECORDTYPEID = RT.ID
    where ((@NAME is null) or (U.NAME like @NAME)) and
          ((@RECORDTYPEID is null) or (U.CONTEXTRECORDTYPEID = @RECORDTYPEID))
    order by U.NAME asc