USP_SEARCHLIST_CALENDARCATALOG

Search for a Calendar.

Parameters

Parameter	Parameter Type	Mode	Description
@NAME	nvarchar(100)	IN	Name
@DESCRIPTION	nvarchar(255)	IN	Description
@CONTEXTRECORDTYPEID	uniqueidentifier	IN	Context record type
@MAXROWS	smallint	IN	Input parameter indicating the maximum number of rows to return.

Definition

Copy



CREATE procedure dbo.USP_SEARCHLIST_CALENDARCATALOG
(
    @NAME nvarchar(100) = null,
    @DESCRIPTION nvarchar(255) = null,
    @CONTEXTRECORDTYPEID uniqueidentifier = null,
    @MAXROWS smallint = 500
)
as
    set nocount on;

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

    select top(@MAXROWS) 
        CALENDARCATALOG.ID,
        CALENDARCATALOG.NAME,
        CALENDARCATALOG.DESCRIPTION,
        RECORDTYPE.NAME CONTEXTRECORDTYPE
    from dbo.CALENDARCATALOG
        left join dbo.RECORDTYPE on CALENDARCATALOG.CONTEXTRECORDTYPEID = RECORDTYPE.ID
    where ((@NAME is null) or (CALENDARCATALOG.NAME like @NAME))
        and ((@DESCRIPTION is null) or (CALENDARCATALOG.DESCRIPTION like @DESCRIPTION))
        and (@CONTEXTRECORDTYPEID is null or CALENDARCATALOG.CONTEXTRECORDTYPEID = @CONTEXTRECORDTYPEID)
        and 1 = dbo.UFN_INSTALLEDPRODUCTS_OPTIONALPRODUCTSINSTALLED
        (
            CALENDARCATALOG.CALENDARSPECXML.query
                (
                    'declare namespace common="bb_appfx_commontypes";
                    /*/common:InstalledProductList'
                )
        )
    order by CALENDARCATALOG.NAME;