USP_DATALIST_STANDINGORDERSEXPORTPROCESS

Returns a list of saved parameter sets for the standing orders export process.

Parameters

Parameter	Parameter Type	Mode	Description
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_STANDINGORDERSEXPORTPROCESS
                (
                    @CURRENTAPPUSERID uniqueidentifier = null
                )
                as
                    set nocount on;

                    select
                        STANDINGORDERSEXPORTPROCESS.ID,
                        STANDINGORDERSEXPORTPROCESS.NAME,
                        STANDINGORDERSEXPORTPROCESS.DESCRIPTION,                        
                        dbo.UFN_IDSET_GETNAME(STANDINGORDERSEXPORTPROCESS.IDSETREGISTERID) as SELECTIONID,
                        dbo.UFN_BUSINESSPROCESSVIEW_GETNAME(STANDINGORDERSEXPORTPROCESS.BUSINESSPROCESSVIEWID) as OUTPUTFORMAT,
                        BPI.OWNERID as OWNERID
                    from dbo.STANDINGORDERSEXPORTPROCESS
                    left join dbo.BUSINESSPROCESSINSTANCE BPI on STANDINGORDERSEXPORTPROCESS.ID = BPI.BUSINESSPROCESSPARAMETERSETID
                    where (dbo.UFN_SECURITY_APPUSER_GRANTED_BUSINESSPROCESSINSTANCE_IN_SYSTEMROLE(@CURRENTAPPUSERID, STANDINGORDERSEXPORTPROCESS.ID) = 1)
                    order by STANDINGORDERSEXPORTPROCESS.NAME;