USP_DATALIST_QUERYVIEWPERMSLIST
Returns list of installed query views, used by Manage System Security.
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_QUERYVIEWPERMSLIST
@SYSTEMROLEID uniqueidentifier
as
set nocount on;
select QV.ID AS QUERYVIEWCATALOGID,QV.DISPLAYNAME, COALESCE(RT.NAME,'') AS RECORDTYPENAME,ROOTOBJECT AS [ISROOT], QV.OBJECTNAME
from
dbo.QUERYVIEWCATALOG AS QV
LEFT OUTER JOIN dbo.RECORDTYPE AS RT ON QV.RECORDTYPEID=RT.ID
ORDER BY DISPLAYNAME,RECORDTYPENAME