USP_DATALIST_GENERATEBATCHPROCESS

This datalist returns a list of generate batch process parameter sets.

Parameters

Parameter	Parameter Type	Mode	Description
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@SHOWINACTIVE	bit	IN	Show inactive
@SITEFILTERMODE	tinyint	IN
@SITESSELECTED	xml	IN
@SECURITYFEATUREID	uniqueidentifier	IN
@SECURITYFEATURETYPE	tinyint	IN

Definition

Copy



CREATE procedure dbo.USP_DATALIST_GENERATEBATCHPROCESS
(
@CURRENTAPPUSERID uniqueidentifier = null, 
@SHOWINACTIVE bit = 0,
@SITEFILTERMODE tinyint = 0,
@SITESSELECTED xml = null,
@SECURITYFEATUREID uniqueidentifier = null,
@SECURITYFEATURETYPE tinyint = null
)

as
    set nocount on;

    select 
        GENERATEBATCHPROCESS.ID,
        GENERATEBATCHPROCESS.NAME,
        IDSETREGISTER.NAME as SELECTION,
        BATCHTEMPLATE.NAME as BATCHTEMPLATE,
        BPI.OWNERID as OWNERID,
        GENERATEBATCHPROCESS.ISACTIVE,
        coalesce(SITE.NAME,'All Sites') SITES
    from dbo.GENERATEBATCHPROCESS
    inner join dbo.IDSETREGISTER on GENERATEBATCHPROCESS.IDSETREGISTERID = IDSETREGISTER.ID
    inner join dbo.BATCHTEMPLATE on GENERATEBATCHPROCESS.BATCHTEMPLATEID = BATCHTEMPLATE.ID
    left join dbo.BUSINESSPROCESSINSTANCE BPI on GENERATEBATCHPROCESS.ID = BPI.BUSINESSPROCESSPARAMETERSETID
    left join dbo.SITE on SITE.ID = BPI.SITEID
    where (dbo.UFN_SECURITY_APPUSER_GRANTED_BUSINESSPROCESSINSTANCE_IN_SYSTEMROLE(@CURRENTAPPUSERID, GENERATEBATCHPROCESS.ID) = 1)
    and (@SHOWINACTIVE = 1 or GENERATEBATCHPROCESS.ISACTIVE = 1)
    and (
            (
                (--Check site security

                 select count(1) 
                 from dbo.UFN_BUSINESSPROCESSPARAMETERSET_GETSITES(GENERATEBATCHPROCESS.ID) as GENERATEBATCHPROCESSSITE 
                 where (dbo.UFN_APPUSER_ISSYSADMIN(@CURRENTAPPUSERID) = 1 or exists (select 1 from dbo.UFN_SITESFORUSERONFEATURE(@CURRENTAPPUSERID,@SECURITYFEATUREID,@SECURITYFEATURETYPE) where SITEID=[GENERATEBATCHPROCESSSITE].[SITEID] or (SITEID is null and [GENERATEBATCHPROCESSSITE].[SITEID] is null)))
                ) > 0
            )
            and (--Apply site filter

                @SITEFILTERMODE = 0
                or BPI.SITEID in (
                select SITEID
                from dbo.UFN_SITE_BUILDDATALISTSITEFILTER (@CURRENTAPPUSERID, @SITEFILTERMODE, @SITESSELECTED) 
                )
            )
        )
    order by GENERATEBATCHPROCESS.NAME