USP_SEARCHLIST_MAPINSTANCE

This search finds all saved map instances.

Parameters

Parameter	Parameter Type	Mode	Description
@NAME	nvarchar(100)	IN	Name
@DESCRIPTION	nvarchar(1000)	IN	Description
@MAXROWS	smallint	IN	Input parameter indicating the maximum number of rows to return.

Definition

Copy



CREATE procedure dbo.USP_SEARCHLIST_MAPINSTANCE
(
    @NAME nvarchar(100) = null,
    @DESCRIPTION nvarchar(1000) = 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)
        ID,
        NAME,
        DESCRIPTION
    from dbo.MAPINSTANCE
    where 
        ((@NAME is null) or (NAME like @NAME)) and 
        ((@DESCRIPTION is null) or (DESCRIPTION like @DESCRIPTION))
    order by NAME;