USP_SIMPLEDATALIST_BUSINESSPROCESSVIEW

A simple data list of available output views for a given business process.

Parameters

Parameter	Parameter Type	Mode	Description
@BUSINESSPROCESSCATALOGID	uniqueidentifier	IN	BUSINESSPROCESSCATALOGID

Definition

Copy



CREATE procedure dbo.USP_SIMPLEDATALIST_BUSINESSPROCESSVIEW(@BUSINESSPROCESSCATALOGID uniqueidentifier = null) as                
    begin                    
        set nocount on

        select 
            ID as VALUE, CAPTION as LABEL 
        from 
            dbo.BUSINESSPROCESSVIEW 
        where 
            BUSINESSPROCESSCATALOGID = @BUSINESSPROCESSCATALOGID
        order by 
            CAPTION
    end