USP_SEARCHLIST_RESOURCE

Allows a user to search for a resource.

Parameters

Parameter	Parameter Type	Mode	Description
@NAME	nvarchar(100)	IN	Name
@RESOURCECATEGORYCODEID	uniqueidentifier	IN	Category
@INCLUDEINACTIVE	bit	IN	Include inactive
@DESCRIPTION	nvarchar(255)	IN	Description
@MAXROWS	smallint	IN	Input parameter indicating the maximum number of rows to return.

Definition

Copy



                CREATE procedure dbo.USP_SEARCHLIST_RESOURCE
                (
                    @NAME nvarchar(100) = null,
                    @RESOURCECATEGORYCODEID uniqueidentifier = null,
                    @INCLUDEINACTIVE bit = null,
                    @DESCRIPTION nvarchar(255) = null,
                    @MAXROWS smallint = 500
                )
                as
                    set @NAME = COALESCE(@NAME,'') + '%';
                    set @DESCRIPTION = COALESCE(@DESCRIPTION,'') + '%';

                    if (@INCLUDEINACTIVE is null)
                        set @INCLUDEINACTIVE = 0;

                    select top(@MAXROWS)
                        RESOURCE.ID,
                        RESOURCE.NAME,
                        dbo.UFN_RESOURCECATEGORYCODE_GETDESCRIPTION(RESOURCECATEGORYCODEID) as RESOURCECATEGORY,
                        RESOURCE.ISACTIVE,
                        RESOURCE.DESCRIPTION
                    from 
                        dbo.RESOURCE
                    where
                         (RESOURCE.NAME LIKE @NAME) and
                         (RESOURCE.DESCRIPTION LIKE @DESCRIPTION) and
                         ((@INCLUDEINACTIVE = 1) or (RESOURCE.ISACTIVE = 1)) and
                         (@RESOURCECATEGORYCODEID is null or @RESOURCECATEGORYCODEID = RESOURCECATEGORYCODEID)
                    order by 
                        RESOURCE.NAME asc