USP_DATALIST_QUERY_AND_FOLDERS

Parameters

Parameter	Parameter Type	Mode
@CURRENTAPPUSERID	uniqueidentifier	IN
@NAME	nvarchar(100)	IN
@ONLYSHOWMYQUERIES	bit	IN
@RECORDTYPEID	uniqueidentifier	IN
@QUERYCATEGORYCODEID	uniqueidentifier	IN
@SITEFILTERMODE	tinyint	IN
@SITESSELECTED	xml	IN
@SECURITYFEATUREID	uniqueidentifier	IN
@SECURITYFEATURETYPE	tinyint	IN
@INCLUDEFOLDERS	bit	IN
@ONLYSHOWMOBILIZED	bit	IN

Definition

Copy



CREATE procedure dbo.USP_DATALIST_QUERY_AND_FOLDERS
(
    @CURRENTAPPUSERID uniqueidentifier, 
    @NAME nvarchar(100) = null, 
    @ONLYSHOWMYQUERIES bit = null,
    @RECORDTYPEID uniqueidentifier = null, 
    @QUERYCATEGORYCODEID uniqueidentifier = null,
    @SITEFILTERMODE tinyint = 0,
    @SITESSELECTED xml = null,
    @SECURITYFEATUREID uniqueidentifier = null,
    @SECURITYFEATURETYPE tinyint = null,
    @INCLUDEFOLDERS bit = 1,
    @ONLYSHOWMOBILIZED bit = 0
)
as
    set nocount on;

    exec USP_DATALIST_QUERY @CURRENTAPPUSERID,
                            @NAME,
                            @ONLYSHOWMYQUERIES,
                            @RECORDTYPEID,
                            @QUERYCATEGORYCODEID,
                            @SITEFILTERMODE,
                            @SITESSELECTED,
                            @SECURITYFEATUREID,
                            @SECURITYFEATURETYPE,
                            @INCLUDEFOLDERS,
                            @ONLYSHOWMOBILIZED;