UFN_CONSTITUENTSBYSITE_FOR_APPUSER_QUERYVIEW

Maps CONSTITUENTIDs to the SITEID of the user in query.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@APPUSERID	uniqueidentifier	IN
@QUERYVIEWCATALOGID	uniqueidentifier	IN

Definition

Copy



CREATE function dbo.[UFN_CONSTITUENTSBYSITE_FOR_APPUSER_QUERYVIEW]
(
  @APPUSERID uniqueidentifier,
  @QUERYVIEWCATALOGID uniqueidentifier
)
returns table
as
  return (
    select distinct [CONSTITUENTSITE].[CONSTITUENTID]
    from dbo.[V_SECURITY_SYSTEMROLEASSIGNMENT_USER_QUERYVIEW] as [SECURITYVIEW]
    inner join dbo.[SITEPERMISSION] on [SITEPERMISSION].[APPUSERID] = [SECURITYVIEW].[APPUSERID] and [SITEPERMISSION].[SYSTEMROLEID] = [SECURITYVIEW].[SYSTEMROLEID]
    inner join dbo.[CONSTITUENTSITE] with (FORCESEEK, INDEX([IX_CONSTITUENTSITE_SITEID])) on [CONSTITUENTSITE].[SITEID] = [SITEPERMISSION].[SITEID]
    where [SECURITYVIEW].[APPUSERID] = @APPUSERID
    and [SECURITYVIEW].[QUERYVIEWCATALOGID] = @QUERYVIEWCATALOGID
    and [SECURITYVIEW].[GRANTORDENY] = 1
    and [SECURITYVIEW].[SITESECURITYMODE] > 1
  );