USP_DATALIST_COAUPDATE

Returns a list of all AddressFinder processes.

Parameters

Parameter	Parameter Type	Mode	Description
@DATATUNEUPID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.
@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_COAUPDATE
                (
                    @DATATUNEUPID uniqueidentifier,
                    @CURRENTAPPUSERID uniqueidentifier,
                    @SITEFILTERMODE tinyint = 0,
                    @SITESSELECTED xml = null,
                    @SECURITYFEATUREID uniqueidentifier = null,
                    @SECURITYFEATURETYPE tinyint = null
                )
                as
                    set nocount on;

                    select 
                        COAUPDATE.ID,
                        COAUPDATE.NAME,                        
                        COAUPDATE.FILEAVAILABLE,
                        case when COAUPDATE.DATELASTRUN is null then N'' else rtrim(left(COAUPDATE.STEP, len(COAUPDATE.STEP) - 3)) end as [LASTACTIVITY],
                        COAUPDATE.DATELASTRUN as [LASTACTIVITYDATE],
                        coalesce(SITE.NAME, 'All sites') as SITE
                    from dbo.COAUPDATE
                        left join dbo.SITE on COAUPDATE.SITEID = SITE.ID
                    where DATATUNEUPID = @DATATUNEUPID
                        and(
                              (
                  COAUPDATE.SITEID is null
                  or
                  (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 SITEID
                                            from dbo.UFN_SITE_BUILDDATALISTSITEFILTER (@CURRENTAPPUSERID, @SITEFILTERMODE, @SITESSELECTED)
                                        )
                                )
                        )
                    order by COAUPDATE.NAME;