USP_DATALIST_CMSSECURITYGROUPCLIENTROLECLIENTSITE

Lists associations between CMS Security Groups and CMS Roles for the specified CMS Site

Parameters

Parameter	Parameter Type	Mode	Description
@CLIENTSITESID	int	IN	CMS Site ID
@CMSSECURITYGROUPID	uniqueidentifier	IN	CMS Security Group ID
@CLIENTROLESID	int	IN	CMS Role ID
@SITETASKSGROUP	bit	IN	Site Tasks Group

Definition

Copy



                    CREATE procedure dbo.USP_DATALIST_CMSSECURITYGROUPCLIENTROLECLIENTSITE
                    (
                        @CLIENTSITESID integer = null,
                        @CMSSECURITYGROUPID uniqueidentifier = null,
                        @CLIENTROLESID int = null,
                        @SITETASKSGROUP bit = null)
                    as
                    set nocount on;

                    select
                            SCRS.ID,
                            CR.[NAME] as RoleName,                                                        
                            CSG.[NAME] as SecurityGroupName,
                            CS.[NAME] as SiteName,
                            SCRS.APPLYTOCHILDREN

                    from dbo.CMSSECURITYGROUPCLIENTROLECLIENTSITE SCRS
                    inner join dbo.CMSSECURITYGROUP CSG on SCRS.[CMSSECURITYGROUPID]=CSG.[ID]
                    inner join dbo.ClientRoles CR on SCRS.[CLIENTROLESID] = CR.[ID]
                    left outer join dbo.CLIENTSITES CS on SCRS.[CLIENTSITESID] = CS.[ID]
                    where (@CLIENTSITESID is null OR SCRS.CLIENTSITESID = @CLIENTSITESID)
                    and (@CMSSECURITYGROUPID is null OR SCRS.CMSSECURITYGROUPID = @CMSSECURITYGROUPID)
                    and (@CLIENTROLESID is null OR SCRS.CLIENTROLESID = @CLIENTROLESID)
                    and (@SITETASKSGROUP is null or CSG.SITETASKSGROUP = @SITETASKSGROUP)