USP_DATALIST_RESEARCHSELECTIONPOPULATEPROCESS

A datalist of saved research group populate process parameter sets.

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_RESEARCHSELECTIONPOPULATEPROCESS (
                    @CURRENTAPPUSERID uniqueidentifier = null,

                    @SITEFILTERMODE tinyint = 0,
                    @SITESSELECTED xml = null,

                    @SECURITYFEATUREID uniqueidentifier = null,
                    @SECURITYFEATURETYPE tinyint = null
                ) as 
                    set nocount on;

                    select
                        RGPP.ID, 
                        RGPP.NAME, 
                        RGPP.DESCRIPTION,
                        RGPP.DATELASTRUN,
                        RG.NAME RESEARCHGROUP,
                        IDSET.NAME as SELECTION,
                        RGPP.POPULATEMETHOD,
                        BPI.OWNERID as OWNERID,
                        (
                            select dbo.UDA_BUILDLIST(SITE.NAME) 
                            from dbo.RESEARCHGROUPSITE
                            inner join dbo.SITE on SITE.ID = RESEARCHGROUPSITE.SITEID
                            where RESEARCHGROUPSITE.RESEARCHGROUPID = RG.ID
                        ) as [SITES]
                    from dbo.RESEARCHGROUPPOPULATEPROCESS RGPP
                    left join dbo.RESEARCHGROUP RG on RG.ID = RGPP.RESEARCHGROUPID
                    left join dbo.IDSETREGISTER as IDSET on RGPP.IDSETREGISTERID = IDSET.ID
                    left join dbo.BUSINESSPROCESSINSTANCE BPI on RGPP.ID = BPI.BUSINESSPROCESSPARAMETERSETID
                    where (dbo.UFN_SECURITY_APPUSER_GRANTED_BUSINESSPROCESSINSTANCE_IN_SYSTEMROLE(@CURRENTAPPUSERID, RGPP.ID) = 1)
                        and (RG.ID is null or dbo.UFN_RESEARCHGROUP_USERHASSITEACCESS(RG.ID, @CURRENTAPPUSERID, @SECURITYFEATUREID, @SECURITYFEATURETYPE) = 1)
                        and
                            (--Apply user-defined site filtering 

                                RG.ID is null 
                                or
                                @SITEFILTERMODE = 0 
                                or 
                                exists (select ID from dbo.RESEARCHGROUPSITE RGS 
                                        inner join dbo.UFN_SITE_BUILDDATALISTSITEFILTER(@CURRENTAPPUSERID, @SITEFILTERMODE, @SITESSELECTED) S on S.SITEID = RGS.SITEID
                                        where RGS.RESEARCHGROUPID = RG.ID) 
                            )
                    order by
                        RGPP.NAME;