USP_SIMPLEDATALIST_ADHOCQUERYFOLDERS

Returns the ad-hoc query folders.

Parameters

Parameter	Parameter Type	Mode	Description
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.

Definition

Copy



                CREATE procedure dbo.USP_SIMPLEDATALIST_ADHOCQUERYFOLDERS
                (
                    @CURRENTAPPUSERID uniqueidentifier
                )
                as
                    set nocount on;

                    select
                        ID as VALUE,
                        NAME as LABEL,
                        PARENTFOLDERID as DESCRIPTION
                    from dbo.UFN_ADHOCQUERYFOLDERS_GETUSERSFOLDERS(@CURRENTAPPUSERID)
                    order by DISPLAYORDER