USP_SEARCHLIST_QUERYVIEW

Search for a query view.

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
@ONLYLISTBUILDER	bit	IN

Definition

Copy



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

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

    with xmlnamespaces ('bb_appfx_queryview' as ns)
    select top(@MAXROWS)
        Q.ID,
        Q.DISPLAYNAME,
        Q.DESCRIPTION,
        RT.NAME as RECORDTYPENAME
    from 
        dbo.QUERYVIEWCATALOG as Q left outer join dbo.RECORDTYPE as RT on Q.RECORDTYPEID = RT.ID
    where ((@NAME is null) or (Q.DISPLAYNAME like @NAME)) and
          ((@RECORDTYPEID is null) or (Q.RECORDTYPEID = @RECORDTYPEID)) and
          ((@ONLYLISTBUILDER <> 1) or (Q.QUERYVIEWSPEC.exist('//ns:ListBuilder') = 1))
    order by Q.DISPLAYNAME asc