UFN_CONSTITUENTSUMMARY_GETAVAILABLETILES

CREATE function dbo.UFN_CONSTITUENTSUMMARY_GETAVAILABLETILES
(
    @CONSTITUENTTYPECODE tinyint,
    @CURRENTAPPUSERID uniqueidentifier
)
returns table
as return
    select
        ID,
        DATAFORMINSTANCECATALOGID TILEID,
        TILENAME,
        SEQUENCE
    from
        dbo.CONSTITUENTSUMMARYAVAILABLETILE
    where
        CONSTITUENTTYPECODE = @CONSTITUENTTYPECODE
        and DATAFORMINSTANCECATALOGID is not null
        and dbo.UFN_DATAFORMINSTANCE_PRODUCTISDATAFORM(DATAFORMINSTANCECATALOGID) = 1 --at least one of the product flags on the tile view form must be installed

        and (
            dbo.UFN_APPUSER_ISSYSADMIN(@CURRENTAPPUSERID) = 1 or
            dbo.UFN_SECURITY_APPUSER_GRANTED_FORM_IN_SYSTEMROLE(@CURRENTAPPUSERID, DATAFORMINSTANCECATALOGID) = 1
        );