USP_DATALIST_FEPSUBMITPROCESS

Returns a list of all FEP processes.

Parameters

Parameter	Parameter Type	Mode	Description
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@SITEFILTERMODE	tinyint	IN	Sites
@SITESSELECTED	xml	IN
@SECURITYFEATUREID	uniqueidentifier	IN	Input parameter indicating the ID of the feature to use for site security checking.
@SECURITYFEATURETYPE	tinyint	IN	Input parameter indicating the type of the feature to use for site security checking.

Definition

Copy



CREATE procedure dbo.USP_DATALIST_FEPSUBMITPROCESS
(
    @CURRENTAPPUSERID uniqueidentifier = null,
    @SITEFILTERMODE tinyint = 0,
    @SITESSELECTED xml = null,
    @SECURITYFEATUREID uniqueidentifier = null,
    @SECURITYFEATURETYPE tinyint = null
)
as
    set nocount on;

    select
        FEPPROCESS.ID,
        FEPSUBMITPROCESS.ID as PARAMETERSETID,
        FEPPROCESS.[NAME],        
        FEPPROCESS.DESCRIPTION,
        coalesce(SITE.NAME, 'All sites') as [SITE]
    from
        dbo.FEPPROCESS
        inner join dbo.FEPSUBMITPROCESS
            on FEPPROCESS.ID = FEPSUBMITPROCESS.FEPPROCESSID
        left join dbo.SITE
            on FEPPROCESS.SITEID = SITE.ID
    where 
        dbo.UFN_SECURITY_APPUSER_GRANTED_BUSINESSPROCESSINSTANCE_IN_SYSTEMROLE(@CURRENTAPPUSERID, FEPPROCESS.ID) = 1
        and (
                (dbo.UFN_APPUSER_ISSYSADMIN(@CURRENTAPPUSERID) = 1 or exists (select 1 from dbo.UFN_SITESFORUSERONFEATURE(@CURRENTAPPUSERID,@SECURITYFEATUREID,@SECURITYFEATURETYPE) where SITEID=[SITE].[ID] or (SITEID is null and [SITE].[ID] is null)))
                and
                (
                    @SITEFILTERMODE = 0
                        or SITE.[ID] in
                        (
                            select SITEFILTER.[SITEID]
                            from dbo.UFN_SITE_BUILDDATALISTSITEFILTER(@CURRENTAPPUSERID, @SITEFILTERMODE, @SITESSELECTED) as [SITEFILTER]
                        )
                )
        )
    order by FEPPROCESS.NAME