USP_SEARCHLIST_BBWORKFLOW

Search for a workflow definition.

Parameters

Parameter	Parameter Type	Mode	Description
@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_BBWORKFLOW
(
    @MAXROWS smallint = 500,
    @NAME nvarchar(255) = null
)
as
    set @NAME = dbo.UFN_SEARCHCRITERIA_GETLIKEPARAMETERVALUE(@NAME, 0, null);

    select top(@MAXROWS)
        W.ID,
        W.NAME,
        W.DESCRIPTION
    from 
        dbo.V_INSTALLED_BBWORKFLOWCATALOG as W
    where ((@NAME is null) or (W.NAME like @NAME)) 
    order by W.NAME asc