UFN_APPUSER_GETAVAILABLESUMMARYTILES

create function dbo.UFN_APPUSER_GETAVAILABLESUMMARYTILES(
    @APPUSERID uniqueidentifier,
    @SUMMARYTILECONTEXTID uniqueidentifier
)
returns table
as
return
(
    select
        AVAILABLESUMMARYTILE.ID,
        AVAILABLESUMMARYTILE.DATAFORMINSTANCECATALOGID,
        AVAILABLESUMMARYTILE.TILENAME,
        AVAILABLESUMMARYTILE.ISVISIBLEBYDEFAULT,
        AVAILABLESUMMARYTILE.SEQUENCE
    from dbo.AVAILABLESUMMARYTILE
    where
        AVAILABLESUMMARYTILE.SUMMARYTILECONTEXTID = @SUMMARYTILECONTEXTID
        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(@APPUSERID) = 1 or
            dbo.UFN_SECURITY_APPUSER_GRANTED_FORM_IN_SYSTEMROLE(@APPUSERID, DATAFORMINSTANCECATALOGID) = 1
        )
)