USP_SIMPLEDATALIST_KPIINSTANCEFOLDERS
Parameters
Parameter | Parameter Type | Mode | Description |
---|---|---|---|
@CURRENTAPPUSERID | uniqueidentifier | IN |
Definition
Copy
create procedure dbo.[USP_SIMPLEDATALIST_KPIINSTANCEFOLDERS]
(
@CURRENTAPPUSERID uniqueidentifier
)
as
set nocount on;
select
[ID] as [VALUE],
[NAME] as [LABEL],
[PARENTFOLDERID] as [DESCRIPTION]
from dbo.[KPIINSTANCEFOLDER]
order by [DISPLAYORDER]