UFN_CONSTITUENTAPPEAL_GRANTEDBYSITE_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_CONSTITUENTAPPEAL_GRANTEDBYSITE_FOR_APPUSER_QUERYVIEW] (
    @APPUSERID uniqueidentifier,
    @QUERYVIEWCATALOGID uniqueidentifier
    )
returns table
as
return (
    select 
      distinct [FACT_CONSTITUENTAPPEAL].[CONSTITUENTAPPEALSYSTEMID] as [ID]
    from BBDW.[V_SECURITY_SYSTEMROLEASSIGNMENT_USER_QUERYVIEW] as [SECURITYVIEW]
        inner join BBDW.[FACT_SITEPERMISSION]    on [FACT_SITEPERMISSION].[SYSTEMROLEAPPUSERFACTID] = [SECURITYVIEW].[SYSTEMROLEAPPUSERFACTID]
        inner join BBDW.[DIM_APPEAL]    on [DIM_APPEAL].[SITEDIMID] = [FACT_SITEPERMISSION].[SITEDIMID]
        inner join BBDW.[FACT_CONSTITUENTAPPEAL] on [FACT_CONSTITUENTAPPEAL].[APPEALDIMID] = [DIM_APPEAL].[APPEALDIMID]
    where    [SECURITYVIEW].[APPUSERID] = @APPUSERID
    and [SECURITYVIEW].[QUERYVIEWCATALOGID] = @QUERYVIEWCATALOGID
    and [SECURITYVIEW].[GRANTORDENY] = 1
    and [SECURITYVIEW].[SITESECURITYMODE] > 1
    );