USP_SEARCHLIST_QUEUEPROCESS

Search for a Queue Process

Parameters

Parameter	Parameter Type	Mode	Description
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@MAXROWS	smallint	IN	Input parameter indicating the maximum number of rows to return.
@NAME	nvarchar(255)	IN	Name

Definition

Copy



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

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

    select top(@MAXROWS)
        ID,
        NAME,
        DESCRIPTION
    from 
        dbo.QUEUEPROCESS
    where
         ((@NAME is null) or ([NAME] like @NAME))
    order by 
        [NAME] asc;