USP_DATALIST_SYSTEMROLEQUERYVIEWPERMS
Displays query views assigned to the given system role
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @SYSTEMROLEID | uniqueidentifier | IN | Input parameter indicating the context ID for the data list. |
| @FILTERRECORDTYPE | uniqueidentifier | IN | Record Type |
Definition
Copy
CREATE procedure dbo.USP_DATALIST_SYSTEMROLEQUERYVIEWPERMS
@SYSTEMROLEID uniqueidentifier,
@FILTERRECORDTYPE uniqueidentifier=NULL
as
select SRP.ID,
case SRP.GRANTORDENY when 0 then 'RES:padlock' else '' end as [IMAGEKEY],
case SRP.GRANTORDENY when 1 then 'Grant' else 'Deny' end,
QV.DISPLAYNAME,
RT.NAME AS 'RECORDTYPENAME',
case QV.ROOTOBJECT when 1 then 'Root' else 'Child' end as [VIEWNODETYPE]
from
SYSTEMROLEPERM_QUERYVIEW as SRP
INNER JOIN dbo.QUERYVIEWCATALOG as QV on SRP.QUERYVIEWCATALOGID=QV.ID
LEFT OUTER JOIN dbo.RECORDTYPE AS RT ON QV.RECORDTYPEID=RT.ID
where SRP.SYSTEMROLEID=@SYSTEMROLEID
and
(RT.ID=@FILTERRECORDTYPE OR @FILTERRECORDTYPE IS NULL)
order by QV.DISPLAYNAME