UFN_APPUSERSUMMARYTILECONTEXT_GETSELECTEDTILES

create function dbo.UFN_APPUSERSUMMARYTILECONTEXT_GETSELECTEDTILES(
    @APPUSERSUMMARYTILECONTEXTID uniqueidentifier
)
returns table
as
return
(
    select
        SELECTEDSUMMARYTILE.ID,
        AVAILABLESUMMARYTILE.DATAFORMINSTANCECATALOGID,
        SELECTEDSUMMARYTILE.SEQUENCE,
        SELECTEDSUMMARYTILE.AVAILABLESUMMARYTILEID
    from dbo.SELECTEDSUMMARYTILE
        inner join dbo.AVAILABLESUMMARYTILE on AVAILABLESUMMARYTILE.ID = SELECTEDSUMMARYTILE.AVAILABLESUMMARYTILEID
        inner join dbo.APPUSERSUMMARYTILECONTEXT on APPUSERSUMMARYTILECONTEXT.ID = SELECTEDSUMMARYTILE.APPUSERSUMMARYTILECONTEXTID
    where
        SELECTEDSUMMARYTILE.APPUSERSUMMARYTILECONTEXTID = @APPUSERSUMMARYTILECONTEXTID
        and dbo.UFN_DATAFORMINSTANCE_PRODUCTISDATAFORM(AVAILABLESUMMARYTILE.DATAFORMINSTANCECATALOGID) = 1 --at least one of the product flags on the tile view form must be installed

        and (
            dbo.UFN_APPUSER_ISSYSADMIN(APPUSERSUMMARYTILECONTEXT.APPUSERID) = 1 or
            dbo.UFN_SECURITY_APPUSER_GRANTED_FORM_IN_SYSTEMROLE(APPUSERSUMMARYTILECONTEXT.APPUSERID, AVAILABLESUMMARYTILE.DATAFORMINSTANCECATALOGID) = 1
        )
)