UFN_SYSTEMROLE_GETSMARTFIELDINSTANCELIST

create function dbo.UFN_SYSTEMROLE_GETSMARTFIELDINSTANCELIST
(
    @SYSTEMROLEID uniqueidentifier
)
/*Returns a table of IDs for all of the smart field instances that have been assigned to the given SYSTEMROLEID.*/
returns table
as
return
(
    select
        SYSTEMROLEPERM_QUERYVIEW.ID,
        SYSTEMROLEPERM_QUERYVIEW.QUERYVIEWCATALOGID,
        SMARTFIELD.ID SMARTFIELDID,
        SYSTEMROLEPERM_QUERYVIEW.GRANTORDENY
    from dbo.SYSTEMROLEPERM_QUERYVIEW
        inner join dbo.QUERYVIEWCATALOG on QUERYVIEWCATALOG.ID=SYSTEMROLEPERM_QUERYVIEW.QUERYVIEWCATALOGID
        inner join dbo.SMARTFIELD 
            on dbo.UFN_SMARTFIELD_GETQUERYVIEWOBJECTNAME(SMARTFIELD.ID)=upper(QUERYVIEWCATALOG.OBJECTNAME)
    where SYSTEMROLEPERM_QUERYVIEW.SYSTEMROLEID = @SYSTEMROLEID
);