USP_DATALIST_SYSTEMROLESMARTFIELDINSTANCE

Returns a list of smart field instances for a given system role.

Parameters

Parameter	Parameter Type	Mode	Description
@SYSTEMROLEID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



create procedure dbo.USP_DATALIST_SYSTEMROLESMARTFIELDINSTANCE(@SYSTEMROLEID uniqueidentifier)
as
    set nocount on;

    select 
        SYSTEMROLEPERM_QUERYVIEW.ID,
        SMARTFIELD.ID SMARTFIELDID,
        SMARTFIELD.NAME,
        SMARTFIELDCATALOG.DESCRIPTION,
        SMARTFIELDCATALOG.DISPLAYNAME TYPE,
        RECORDTYPE.NAME RECORDTYPE
    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)
        inner join dbo.SMARTFIELDCATALOG on SMARTFIELD.SMARTFIELDCATALOGID = SMARTFIELDCATALOG.ID
        inner join dbo.RECORDTYPE on RECORDTYPE.ID=SMARTFIELDCATALOG.RECORDTYPEID
    where SYSTEMROLEPERM_QUERYVIEW.SYSTEMROLEID = @SYSTEMROLEID;