Exago .NET API Documentation
DbRowLimitParamName Property
WebReports.Api.Common Namespace > General Class : DbRowLimitParamName Property

The Programmable Object Settings enable you to specify names for special parameters that will be passed from Exago to identically named parameters in stored procedures or .NET Assemblies. Using these parameters will allow filtering to be done before the data is sent to Exago. This can increase performance and reduce server resources when using Programmable Objects. For more information on these types of Data Objects see Web Services & .NET Assemblies.

If an Exago .NET API application needs to access reports with an assembly data source, it must include a reference to the assembly WebReportsAsmi.dll.
Provide the name of a parameter holding the Database Row Limit, the maximum number of rows returned on an execution.Maximum number of rows returned on an execution. This only applies to Tables, Views and Functions. Set to 0 to return all rows.
public System.string DbRowLimitParamName {get; set;}

Property Value

The unique name for a parameter to be made accessible in the programmable object.An positive integer or 0 as described above.
Same as setting Admin Console > General > Database Settings > Database Row Limit.
This is a sample stored procedure that use the Programmable Object Settings parameters.
CREATE PROCEDURE [dbo].[sp_webrpt_person]
@callType INT,
@columnStr varchar(1000),
@filterStr varchar(1000),
@fullFilterStr varchar(1000),
@sortStr varchar(1000)
SET NOCOUNT ON /*for performance reasons */
SET FMTONLY OFF /*force procedure to return data and process IF conditions */
declare @sql varchar(2000)
declare @columnInfo varchar(1000)
declare @orderbyClause varchar(1000)
declare @operator varchar(max)
if @callType = 0 /*return schema; no need to return any rows */
 set @sql = 'select * from vw_webrpt_person where 0 = 1'
if @callType = 1 /*return all data for execution */
 set @orderbyClause = ''
 if @sortStr is not NULL AND @sortStr <> 'null' set @orderbyClause = ' ORDER BY ' + @sortStr
 set @sql = 'select ' + @columnStr + ' from vw_webrpt_person where ' + @filterStr + @orderbyClause
if @callType = 2 /*return filter dropdown values; limit # rows to some value; sortStr will indicate which direction user is scrolling the dropdown*/
set @orderByClause = ''
 set @operator = ' >= '
 if @sortStr is not NULL AND @sortStr <> 'null' AND @sortStr <> '' Begin SET @orderByClause = ' ORDER BY ' + @sortStr END
 if (RIGHT(@sortStr, 4) = 'DESC')Begin SET @operator = ' <= 'END
 set @columnInfo = '[' + @columnStr + ']'
 SET @sql = 'select top 100 ' + @columnInfo + ' from Northwind.dbo.OrderDetails where ' + @columnInfo + @operator + @filterStr + ' AND ' + @fullFilterStr + @orderByClause
Setting the name of five Programmable Object Parameters that will be passed to the above stored procedure when queried
api.General.CallTypeParamName = "callType";
api.General.ColumnParamName = "columnStr";
api.General.FilterParamName = "filterStr";
api.General.FullFilterParamName = "fullFilterStr";
api.General.SortParamName = "sortStr";
See Also


General Class
General Members

Exago Knowledge Base

Programmable Object Settings
Data Sources > .NET Assemblies
Database Settings