UFN_CONSTITUENTSBYSITE_FOR_APPUSER_QUERYVIEW

Return

Return Type
table

Parameters

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

Definition

Copy


CREATE function BBDW.[UFN_CONSTITUENTSBYSITE_FOR_APPUSER_QUERYVIEW] 
  (  
    @APPUSERID uniqueidentifier,  
    @QUERYVIEWCATALOGID uniqueidentifier  
  )  returns table as

    return

      select 
        distinct cs.[CONSTITUENTSYSTEMID] as [CONSTITUENTID]
      from BBDW.[V_SECURITY_SYSTEMROLEASSIGNMENT_USER_QUERYVIEW] qs
      inner join BBDW.[FACT_SITEPERMISSION] s on s.[SYSTEMROLEAPPUSERFACTID] = qs.[SYSTEMROLEAPPUSERFACTID]
      inner join BBDW.[FACT_CONSTITUENTSITE] cs on cs.[SITEDIMID] = s.[SITEDIMID]
      where qs.[QUERYVIEWCATALOGID] = @QUERYVIEWCATALOGID 
      and qs.[APPUSERID] = @APPUSERID
      and qs.[GRANTORDENY] = 1
      and qs.[SITESECURITYMODE] > 1;