USP_DATALIST_GENERATESTEPUPDATEBATCHPROCESS

This datalist returns a list of generate step 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

Definition

Copy



CREATE procedure dbo.USP_DATALIST_GENERATESTEPUPDATEBATCHPROCESS
(
  @CURRENTAPPUSERID uniqueidentifier = null, 
  @SHOWINACTIVE bit = 0
)
as
  set nocount on;

  select 
    GENERATESTEPUPDATEBATCHPROCESS.ID,
    GENERATESTEPUPDATEBATCHPROCESS.NAME,
    IDSETREGISTER.NAME as SELECTION,
    BATCHTEMPLATE.NAME as BATCHTEMPLATE,
    BPI.OWNERID as OWNERID,
    GENERATESTEPUPDATEBATCHPROCESS.ISACTIVE
  from dbo.GENERATESTEPUPDATEBATCHPROCESS
  inner join dbo.IDSETREGISTER on GENERATESTEPUPDATEBATCHPROCESS.IDSETREGISTERID = IDSETREGISTER.ID
  inner join dbo.BATCHTEMPLATE on GENERATESTEPUPDATEBATCHPROCESS.BATCHTEMPLATEID = BATCHTEMPLATE.ID
  left join dbo.BUSINESSPROCESSINSTANCE BPI on GENERATESTEPUPDATEBATCHPROCESS.ID = BPI.BUSINESSPROCESSPARAMETERSETID
  where (dbo.UFN_SECURITY_APPUSER_GRANTED_BUSINESSPROCESSINSTANCE_IN_SYSTEMROLE(@CURRENTAPPUSERID, GENERATESTEPUPDATEBATCHPROCESS.ID) = 1)
  and (@SHOWINACTIVE = 1 or GENERATESTEPUPDATEBATCHPROCESS.ISACTIVE = 1)
  order by GENERATESTEPUPDATEBATCHPROCESS.NAME