USP_DATALIST_GLOBALCHANGE

Returns a list of global changes.

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_GLOBALCHANGE
(
  @CURRENTAPPUSERID uniqueidentifier,
  @SITEFILTERMODE tinyint = 0,
  @SITESSELECTED xml = null,
  @SECURITYFEATUREID uniqueidentifier = null,
  @SECURITYFEATURETYPE tinyint = null
)
as
  set nocount on;         

  select 
    GLOBALCHANGE.ID,
    GLOBALCHANGE.NAME,
    GLOBALCHANGECATALOG.DISPLAYNAME, 
    GLOBALCHANGECATALOG.ID,
    coalesce(GLOBALCHANGE.GLOBALCHANGEDATAFORMITEM,''),
    GLOBALCHANGE.LASTRUNON,
    BPI.OWNERID as OWNERID,
    coalesce(SITE.NAME,'All sites') SITES,
    APPUSER.USERNAME OWNER
  from dbo.GLOBALCHANGE
    inner join dbo.GLOBALCHANGECATALOG on GLOBALCHANGECATALOG.ID = GLOBALCHANGE.GLOBALCHANGECATALOGID
    left join dbo.BUSINESSPROCESSINSTANCE BPI on BPI.BUSINESSPROCESSPARAMETERSETID = GLOBALCHANGE.ID
    left join dbo.SITE on SITE.ID = BPI.SITEID
    left join dbo.APPUSER on APPUSER.ID = BPI.OWNERID
  where 
    dbo.UFN_SECURITY_APPUSER_GRANTED_BUSINESSPROCESSINSTANCE_IN_SYSTEMROLE(@CURRENTAPPUSERID, GLOBALCHANGE.ID) = 1 and 
    (
      (
        (--Check site security

          select 
            count(*) 
          from 
            dbo.UFN_SITEID_MAPFROM_GLOBALCHANGEPROCESSID(GLOBALCHANGE.ID) as GLOBALCHANGEPROCESSSITE 
          where 
            (dbo.UFN_APPUSER_ISSYSADMIN(@CURRENTAPPUSERID) = 1 or exists (select 1 from dbo.UFN_SITESFORUSERONFEATURE(@CURRENTAPPUSERID,@SECURITYFEATUREID,@SECURITYFEATURETYPE) where SITEID=[GLOBALCHANGEPROCESSSITE].[SITEID] or (SITEID is null and [GLOBALCHANGEPROCESSSITE].[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
    GLOBALCHANGECATALOG.DISPLAYNAME, GLOBALCHANGE.NAME;